Need help with small SQL syntax

[WanknessHD]

("SELECT id,name FROM ranks WHERE id < 7 ORDER BY id DESC")
I would like to grab rows 3-7 only. How could I do that?

@Elijah

 

[Elijah]

You can do something like
"SELECT id,name FROM ranks WHERE id < 7 AND id > 3 ORDER BY id DESC"
That should help

 

[WanknessHD]

That would make sense, I tried ("SELECT id,name FROM ranks WHERE id < 7 > 3 ORDER BY id DESC") But that broke the page lmao, I dont know too much SQL
 
Thanks man it worked, means a lot!

 

[Elijah]

That would make sense, I tried ("SELECT id,name FROM ranks WHERE id < 7 > 3 ORDER BY id DESC") But that broke the page lmao, I dont know too much SQL

Yeah, you need to add the AND. It will check each operator, so you can't do < 7 > 3.

edit: No prob