MYSQL 5 auto increment not working
| From: | Leidago !Noabeb | Date: | Thu, 21 May 2009 13:05:30 +0000 |
| Subject: | MYSQL 5 auto increment not working | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-292862@lists.php.net to get a copy of this message | ||
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?