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