I didn't understand exactly what you want, I think...
You want something like this?
PHP Code:
$sql = "SELECT * FROM table";
if(is_numeric($_GET['row']))$sql.=" LIMIT ".$_GET['row'].",1";
$res = mysql_query($sql);
switch(mysql_num_rows($res))
{
case 0:
// no rows found
break;
case 1:
// display only one row
break;
default:
// display whole table
}
Now you can select exactly one row by linkinf to the url yourscript.php?row=10 (to show the 10th row).
Something like this?