Re: validation & inserts not working

haliphax wrote: > On Wed, Mar 11, 2009 at 4:29 PM, PJ <af.gourmet@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, > Ok, but why is it doing that? I like to "understand" - I must have asked too many questions when I was a kid... it stuck. :-) -- unheralded genius: "A clean desk is the sign of a dull mind. " ------------------------------------------------------------- Phil Jourdan --- pj@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php