If you are using an auto_increment primary key field named id, then you would use this:
SELECT * FROM table WHERE id=2 LIMIT 1
Just so long as you know that if for some reason you delete that row, there will NEVER
Be another id of 2, unless you set it that way.
If you only want to select certain columns from the row, then list those columns in
place of the wildcard.
SELECT first_name, last_name FROM table WHERE id=1 LIMIT 1
Developer's Forums: http://www.completesource.net/forums/
>>> "Phil Schwarzmann" <[EMAIL PROTECTED]> 07/17/02 10:21AM >>>
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php