haliphax wrote:
> 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,
>
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@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
