Leidago !Noabeb wrote:
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` char(50) default NULL, `csname` char(50) default NULL, PRIMARY KEY (`cid`) ) ENGINE=InnoDB I use PHP 5.1 and MYSQL 5 I'm pretty sure the code i use to insert the data is sound since i've tested it with older versions of MYSQL. Has anyone else had similar problems?
*works for me* check cid is empty in your insert statement check you haven't hit 9999 rows, seeing as you are using int 4 drop and recreate the table (or truncate) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
