On Wed, Mar 11, 2009 at 4:29 PM, PJ <af.gourmet@xxxxxxxxxxxx> 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
