Paul, The obvious question is "Why do that?" If there is a certain criteria you want to meet, it's generally better to do that in your select statement.
Having got that out of the way, $result = mysql_query("SELECT * FROM a_table"); $num_rows = mysql_num_rows($result); returns the number of rows you have fetched, then use mysql_data_seekI() to position the result pointer ... mysql_data_seek( $result, 3 ) will put you on the 4th row. It's all at http://www.php.ca/manual/en/function.mysql-data-seek.php, but I'll repeat, as a rule of thumb, do your work in the select statement, if possible. Cheers - Miles At 03:10 PM 1/16/2002 -0500, Phil Schwarzmann wrote: >After I make a query....how do I fetch a specific row from that query ?? > >Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]