PJ 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 ?
I'm not sure you can, and for good reason. MySQL keeps track of last id
in an autoincrement even if you deleted the record. You don't want ID
clashes even with records that have been deleted. What if they were
accidentally deleted and need to be restored from backup? Now you will
have an ID conflict because an old record and new record will have same
ID. That's why mysql will not use a record id in autoincrement that has
been used before, even if it appears to be available.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
