[SOLVED] Last rows in a table

[rondog]

Hi,

I was wondering how I could select the last 5 rows in a table? I know I could do mysql_num_rows and then subtract 1 then 2 then 3 etc to get it, but I was wondering if their is a better way to do it. Thanks!

[Rohan Shenoy]

<?php
$sql="SELECT * FROM table_name ORDER BY id DESC LIMIT 0,5";
//selects the last 5 rows.
?>

[revraz]

That gives the last 5 IDs.  As long as you use auto increment that should work fine.  But if you do any type of manual ID numbering, that may not be what you want.

[rondog]

<?php
$sql="SELECT * FROM table_name ORDER BY id DESC LIMIT 0,5";
//selects the last 5 rows.
?>

 

cool that worked thanks!

 

@rev. I do have auto incrementing fields, but you are right if their wasn't an auto increment field, it would be tough.

[revraz]

Nah, just use a unix time stamp instead if you run into that.