Selecting a row?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Selecting a row?

Post 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
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post by d3ad1ysp0rk »

what exactly do you mean by "a certain row"

Like.. the 5th row down? Or the row where the name is "Steve"??
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

the 5th row down :)
Robert Plank
Forum Contributor
Posts: 110
Joined: Sun Dec 26, 2004 9:04 pm
Contact:

Post 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.
Post Reply