Re: validation & inserts not working

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, -- // Todd