[SOLVED] get back the row i just added.

[severndigital]

ok ... so let say i have an sql statement

$sql = "INSERT INTO table (firstName,lastName,userName,password) VALUES ('$firstname','$lastname','$username','$password')";
//then i do the query

$add = mysql_query($sql);

 

this there a mysql statement i can use to retrieve the primary key value for the line i just added?? or better yet a statement that i can use to call ANY field from the line i just added.

 

I was hoping for something that works like mysql_rows_affected() .. where i don't need to do any extra calls to mysql

 

Thanks,

-C

 

 

[rhodesa]

use http://us2.php.net/mysql_insert_id to get the primary key, then you can SELECT the row on that

[severndigital]

AHHH .. i knew it had to be there .

 

Thanks

 

C