Re: querying for one specific row number
| From: | 1LT John W. Holmes | Date: | Wed, 17 Jul 2002 15:40:35 +0000 |
| Subject: | Re: querying for one specific row number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-108098@lists.php.net to get a copy of this message | ||
> 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...