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 ?
--
unheralded genius: "A clean desk is the sign of a dull mind. "
-------------------------------------------------------------
Phil Jourdan --- pj@xxxxxxxxxxxxx
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
