comparing 2 tables .

[harishsai]

Hi all;
I need to query 2 tables separately where field result = "pass".the recordset are $result1& $ result2.
now I need to compare these 2 recordsets to find the data which has same value in both.

my coding is as follows:
while($row1=mysql_fetch_array($result1)){
while($row2=mysql_fetch_array($result2)){
if($row1["dbb"]==$row2["dbb"]{
echo $row2["dbb"];
}
}

this coding doesn't works.
can anyone help me out to solve this problem
thankx in advance.
harish

[van__]

Well, this has a syntax error...
if($row1["dbb"]==$row2["dbb"]{
...should be...
if($row1["dbb"]==$row2["dbb"]){

And I really don't like the idea of whiling within a while...

could you try...
<?
for($i=0;$i<mysql_num_rows($result1);$i++) {
$row1[$i] = mysql_fetch_array($result1, MYSQL_ASSOC);
}

for($i=0;$i<mysql_num_rows($result2);$i++) {
$row2[$i] = mysql_fetch_array($result2, MYSQL_ASSOC);
}

// we now have two hash tables

//lets loop and compare...
foreach ($row1 as $key=>$val) {
if ($row1[$key]['dbb'] == $row2[$key]['dbb']) {
echo $row2["dbb"];
}
}
?>

[harishsai]

here I find we are looping only outer $row1, & we are incrementing $row2.

so how to do both.
can u suggest me.