2009/5/21 Leidago !Noabeb <leid...@googlemail.com>
> 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
> it with older versions of MYSQL.
> Has anyone else had similar problems?
Did you left empty the field `cid` (PK) in your INSERT statement?