[PHP-DB] determine the primary key after adding a row to a table (mysql)

2002-04-24 Thread CJ 

is there any way to determine the primary key of a row after it's added to a
table in mysql?

i need to do this because i have another table which requires the id from
one table as a foreign key.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Fw: [PHP-DB] determine the primary key after adding a row to a table (mysql)

2002-04-24 Thread Richard Emery 

$lastid = mysql_last_id();

returns auto_increment from inserted record
- Original Message -
From: CJ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 4:19 PM
Subject: [PHP-DB] determine the primary key after adding a row to a table
(mysql)


is there any way to determine the primary key of a row after it's added to a
table in mysql?

i need to do this because i have another table which requires the id from
one table as a foreign key.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php