Thanks Jason,
That was the answer I was looking for! It works like you suggested!!
Thanks
regards,
bart
-Oorspronkelijk bericht-
Van: Jason Wong [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 28 januari 2002 13:52
Aan: [EMAIL PROTECTED]
Onderwerp: Re: [PHP-DB] mysql_insert_id
On Monday 28 January 2002 20:18, B. Verbeek wrote:
> I already run the query without the value of the primary-key field:
>
> $q_orders_id2 = "INSERT INTO orders(orders_datum, orders_sessid)";
> $q_orders_id2.= " VALUES ('$date', '$sid')";
> $r_orders_id2 = mysql_query($q_orders_id2, $sqllink
sql_query()...
>>How do I define a linkidentifier for a specific call to
mysql_query() and then use mysql_insert_id() with that
linkidentifier of the query?
regards
Bart
-Oorspronkelijk bericht-
Van: Alberto. Sartori [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 28 januari 2002 13:11
Aan:
Hello,
How do I use the linkidentifier to get me the last_inserted_id
(mysql_insert_id) from a auto_increment-colomn?
Do I use:
>>
$q_orders_id2 = "INSERT INTO orders(orders_datum, orders_sessid)";
$q_orders_id2.= " VALUES ('$date', '$sid')";
$r_orders_id2 = mysql_query($q_orders_id2, $sql