SELECT multiple times

[Devine]

I want to select multiple tables into each other like:

$SQL = "select * from XXX where XX = '$X'";
$result = mysql_query( $SQL );
while( $row = mysql_fetch_array( $result ) )
{
$puid = $row["id"];
$prid = $row["productid"];
echo"blah$puid - ";

$SQL2 = "select * from XXX where XX = '$X'";
$result = mysql_query( $SQL2 );
while( $row = mysql_fetch_array( $result ) )
{
$puid = $row["id"];
$prid = $row["productid"];
echo"blah$puid - ";

}
}

[liquorvicar]

you need to make sure you rename $result and $row for the second query or they will overwrite the values for the first query.

[Devine]

Ok, thank you 🙂