[perleo]

I have a mysql db but i want mysql to select with a limit for 4 rows but it must be the last 4 rows in the table as this db will be updated daily.

PHP Code:

$sql = "SELECT * FROM news LIMIT 0, 4"; 

how do I do this ?

[mdhall]

PHP Code:

$sql = "SELECT * FROM news LIMIT 0, 4"; 

You can use this...

$sql = "SELECT * FROM news ORDER BY id DESC LIMIT 4";

This gives you the 4 newest entries, in descending order. Use ASC to reverse them.
Also can by ordered by timestamp, if you have one inserted in a field.