sql statement?

[lukeurtnowski]

How do I make a sql statement to get the last inputted record.

$sql = "SELECT R_ID FROM REVIEW WHERE ID = '?'";

Where ID is an autonumber field in the review table?
Thanks...

[shonuff]

mysql_insert_id

[lukeurtnowski]

this appears to work, is this right?

$sql = "SELECT ASP_ID FROM PROVIDER WHERE ASP_ID = ". mysql_insert_id();

[cgraz]

looks right to me (assuming you're executing the $sql variable) 😉

[bradgrafelman]

If you're just trying to get the last ID, you don't need an extra SQL statement...

$sql = 'INSERT INTO PROVIDER ....';
$exec = mysql_query($sql);

echo 'New ID: ' . mysql_insert_id();