[PHP] Synchronizing autonumber fields

Hi I have the following tables setup in MYSQL: Region 1 Region 2 HQ Tbl1 with autonumbered (PK) Tbl1 with autonumbered (PK) Tbl1 autonumbered-PK To explain the above. Basically there are two regions that collect information

[PHP] MYSQL 5 auto increment not working

Hi All I know this is not strictly a PHP question, but i have a problem whenever i insert a record using PHP. Basically the auto increment field does not work at all. Here's the structure of the table that i'm using: CREATE TABLE `children` ( `cid` int(4) NOT NULL auto_increment, `cname` cha