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 > tested > it with older versions of MYSQL. > > Has anyone else had similar problems?
Did you left empty the field `cid` (PK) in your INSERT statement?
