Getting The Highest ID's record in Mysql+PHP

Python

Ok, basically what I have is a table which has got a load of data stored in it.

There is a column calld ID which is unique and is auto_increment.

What I want to do is to extract the row which has the highest ID number and put it into an array.



How can this be done? Thanks

Forge

[php]

$query = "SELECT * FROM table ORDER BY id DESC LIMIT 1";
$result = mysql_query($query);

[/php]

Should work..

Python

but wont that order the id's from lowest to highest and then only select the top one.

Wouldnt it need to order them highest to lowest and then only select one?

CannonBallGuy

It's descending... from highest to lowest....

Forge wrote:

$query = "SELECT * FROM table ORDER BY id DESC LIMIT 1";
$result = mysql_query($query);

Python

ahh yes i thought so

Thanks

aenigma

$query = "SELECT MAX(ID) AS idmax FROM table";
$result = mysql_query($query);