mysql_seel_data question
Posted: Fri Sep 19, 2003 4:08 am
Hello all,
I made 2 quries in 2 different tables.
What I want is to loop all values of one of my result and look if somewhere there is the same value in the second table result and get this row to compare.
example:
$result = mysql_query(sqlstmt);
$result2 = mysql_query(sqlstmt2);
while ($arr=mysql_fetch_array($result))
{
/*Here I need to look for a specific filed value in $result 2*/
if($arr['name'] exsists in $result2)
fetch_row in $result2
}
of course dont mind the syntax, its just to get my idea crossed.
Thanks
I made 2 quries in 2 different tables.
What I want is to loop all values of one of my result and look if somewhere there is the same value in the second table result and get this row to compare.
example:
$result = mysql_query(sqlstmt);
$result2 = mysql_query(sqlstmt2);
while ($arr=mysql_fetch_array($result))
{
/*Here I need to look for a specific filed value in $result 2*/
if($arr['name'] exsists in $result2)
fetch_row in $result2
}
of course dont mind the syntax, its just to get my idea crossed.
Thanks