How to get 10 entries from a database

[1bigbear]

I am trying to get 10 entries from a database, but how to do this, the entries have an id number if I take them according with the id number some problems will appear when I delete some of the entries.

 

What to do?

[Mchl]

SELECT * FROM table WHERE ... LIMIT 10

[1bigbear]

I found this

$sql="SELECT * FROM data order by id desc limit 10";

 

but what to use so that query gets only the id that is lower that 1000?

[gizmola]

I'd highly recommend a decent tutorial on SQL.

 

$sql="SELECT * FROM data WHERE id