PHP/MySQL problem

[ghus32]

Hello Everyone,

I am haveing trouble using the results from one query in another query.

$Query= "SELECT email.email, email.id, usermap.id, usermap.email
FROM email
LEFT JOIN usermap ON usermap.email = email.id
WHERE email.email = '$email' ";
$Result = mysql_query( $Query );

$Lookup = "<user_lookup>";
while ( $lookup = mysql_fetch_object( $Result ) )
{
$Lookup .= "<id>".$lookup->id."</id>";

}
$Lookup .= "</user_lookup>";



This query gives me a sigle result and I want to use this result but it is not working..

any suggestions?

 

[vacunita]

I posted in your other thread in the php forum here:

thread434-1461578

Please don't double post, it makes keeping answers continuous very difficult.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.