Re: querying for one specific row number
| From: | Justin French | Date: | Thu, 18 Jul 2002 05:33:23 +0000 |
| Subject: | Re: querying for one specific row number | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-108210@lists.php.net to get a copy of this message | ||
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 (pschwar@jhmi.edu) 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??
>
> THANKS!!
>