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?? > > THANKS!! > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php