For starters, this is a PHP list, not MySQL.

Check out the LIMIT statement in the MySQL manual.

Or, if you have a primary key field like id and you KNOW that id#2 will be
there, then it's a simple

SELECT * FROM mytable WHERE id='2'

But in the case where id#2 has been deleted, you really want to pull out
id#3, the new second rown in the table... in which case you'd use limit

make sense?

Justin French

on 18/07/02 12:21 AM, Phil Schwarzmann ([EMAIL PROTECTED]) wrote:

> I want query my mysql table and get one particular row.
> So let's say my table had 5 rows (entries) in it, and I want to pull
> just row #2, how would I do this??

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to