Extract last row of a query.

[contiw]

How to extract the last row a query and store it in a variable  ?

Thanks for helping.

Noob apppreciate.

[AbraCadaver]

Reverse the ORDER BY and then extract the first row with *_fetch_array() or similar function.

[Adam]

AbraCadaver's method is what you should go with, but if not possible for whatever reason here's an alternative that will advance the result pointer to the last row returned:

 

$total = mysql_num_rows($query);
mysql_data_seek($query, $total-1);

Once you've "seeked" to the last row, mysql_fetch_*() will return the data.

[contiw]

Thanx MrAdams, AbraCad.