[SOLVED] Is there a way of selecting data from a particular row number?

[madspof]

Is there a way of selecting data from a field from where you no a specific row number for example

 

SELECT name FROM users WHERE rownum = "1"

[madspof]

BUmp

[Philip]

SELECT name FROM users LIMIT 5,1

would grab row 6

[madspof]

But if i know the row number for example in the variaible $num how would i implement that into the ode above ?

[Philip]

$query = mysql_query("SELECT name FROM users LIMIT ".($num-1).", 1");

 

[madspof]

haha sorry about that i did it in the end before you posted lol i was being such a dumb ass lol anyway thanks for the help :-)