Get data of last row in php?

[Anon]

Dear all,

I want to get the first 5 row of data in php in the following,

$sql="select id,num
from data where num >0 order by id DESC limit 5";

For example, if the last row of data with num=11, the data sql selected may not includes all data with num=11. I would like to also include all the data with num=11.

Please give me some help on the sql command, thanks

Simon

[Anon]

You have to use 2 numbers for limits.

Like this:

SELECT id,num FROM data WHERE num > 0 ORDER BY id DESC LIMIT 0,5