[Resolved] [Resolved] Selecting the most recent id

[Davidc316]

Hi,

I have a table with an 'id' column (int, primary key, auto_increment).

When someone adds a new record to this table, the id goes up by one.

Does anyone know a way to select the most recent ID from the table?

• The most recent ID also happens to be the id with the highest number (I'm not sure if that helps or not). *

Many Thanks

[AshtrayWaterloo]

$sql = "SELECT MAX(id) FROM MyTable";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$id = $row[0];
mysql_free_result($result);

Since it's autoincrement, the highest existing ID in the table will, by definition, be the latest one added.
Just change your column name and table name to what you want and it should be good to go.

Ash

[Drakla]

If you want the last ID that your current script added use

$sql = "SELECT last_insert_id()"; 
$result = mysql_query($sql); 
$row = mysql_fetch_array($result); 
$id = $row[0]; 
mysql_free_result($result);

If somebody adds to the table outside your script you'll still get the last insert you did. But note if you do a multiple insert it gives back the insert id of the FIRST insert, i.e. if the table had a current ID of 4, and you did:

insert blahblah (somefield) values (10),(12),(2);

You'd get back 5, not 7

[Davidc316]

Many thanks guys!

I couldn't have hoped for a better response.