Page 1 of 1

Selecting a row?

Posted: Sun Dec 26, 2004 8:06 pm
by Joe
Is there a MySQL query that I can use which will allow me to select a certain row from a table?.

Regards


Joe

Posted: Sun Dec 26, 2004 8:48 pm
by d3ad1ysp0rk
what exactly do you mean by "a certain row"

Like.. the 5th row down? Or the row where the name is "Steve"??

Posted: Sun Dec 26, 2004 9:11 pm
by Joe
the 5th row down :)

Posted: Sun Dec 26, 2004 9:33 pm
by Robert Plank
In that case you will have to have "LIMIT 4, 1" at the end of your query (counting starts at 0, so the 5th row will be 4) and then use mysql_fetch_array or mysql_result or whatever to get the values from the row.