On Wed, Mar 11, 2009 at 4:29 PM, PJ <af.gour...@videotron.ca> wrote: > Lex Braun wrote: >> PJ, >> >> >>> <snip> >>> >>>> $sql1 = "INSERT INTO book ( title, sub_title, descr, >>>> comment, bk_cover, copyright, ISBN, language, sellers ) >>>> VALUES ('$titleIN', '$sub_titleIN', '$descrIN', '$commentIN', >>>> '$bk_coverIN', '$copyrightIN', '$ISBNIN', '$languageIN', >>>> '$sellersIN')"; >>>> $result1 = mysql_query($sql1, $db); >>>> $autoid = mysql_insert_id($result1); >>>> >> >> You're actually sending mysql_insert_id() the wrong parameter. It should be: >> $autoid = mysql_insert_id($db); // you send the resource of your MySQL >> connection (http://ca3.php.net/manual/en/function.mysql-insert-id.php) >> This should be corrected in everywhere you call mysql_insert_id() >> >> -Lex >> >> > I tried this (from the link above) > $result1 = mysql_query($sql1, $db); > $autoid = mysql_insert_id(); > echo $autoid; > works... > > but now, I have another problem... I am trying to debug this thing by > going 1 query at a time ( I comment out the rest): every time I do an > INSERT INTO book... the insert works fine but the ID is increased not > from the highest id value but from the last id inserted. So my highest > at the moment is 11; I insert test data and it goes in as id = 15; I > delete this field and redo an insert and it goes in as id = 16. How can > I change this so the auto_increment continues from the 11 ?
In MySQL, ALTER TABLE [tablename] AUTO_INCREMENT = [value]; HTH, -- // Todd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php