Re: [PHP] querying for one specific row number From: 1LT John W. Holmes (holmes072000 <email protected>)
Date: 07/17/02

> 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??

What is row #2?? The second row when the table is ordered by the first
column? second column? ascending? decending? without an ORDER BY in your
query...row #2 can be different every time.

Once you add your ORDER BY, you can use LIMIT 1,1 on the end of your query
to have it just return the second row.

---John Holmes... 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php