another SQL question

[nabeels786]

ive got

$sql="SELECT gamename FROM reviews WHERE id='$id'";
$result = mysql_query($sql);   
while ($row = mysql_fetch_row($result)) {
                                        
$gamename=$row['gamename'];

}

$sql="SELECT * FROM reviews WHERE gamename='$gamename'";
$result = mysql_query($sql);  
 
while ($row = mysql_fetch_row($result)) {
                                        
//outputs the results into a table
//new table for every review
} 

any problems with that? i want to get one id, but pull up reviews for multiple entries for that game.

also, i'm a bit confused. suppose i have multiple reviews for the game x. wouldnt it pull up the first review it finds?