Compare Data in one table

[sri_hai1986]

I need to compare a data between one tables.
i have a datbase....

product_dteails..(productid,linenumber,test,subtest.)

for 1 produc i have 100 test.so i have to compare 2 product.first i need to take one test from the product 1 and search the test of the product 1 in all the enteries of the product 2,if it is not found we shold return the test.

Can anyone help me???

[sri_hai1986]

This is the program i have done

function compare($prodid,$prodid1)
{

// Print special attachment list
global $link;
$query1 = "SELECT State,Tag_Name,Passcount,Test,Sub_Test,Passcount FROM product_details where Product_ID='$prodid'";
$result1 = mysql_query( $query1, $link);
$resultrow=mysql_num_rows($result1);
if ($resultrow ==0)
{
	print "failed to open $table<p>";
	//return false;
}
else
{
while($row = mysql_fetch_array($result1))
{
global  $test;
global $subtest;
$test= $row[Test];
$subtest=$row[Sub_Test];

$query2 = "SELECT Test,Sub_Test FROM product_details where Product_ID='$prodid1'";
$result2 = mysql_query( $query2, $link);
$resultrow1=mysql_num_rows($result2);

if ($resultrow1 == 0)
{
print "Test:$test<br>";
print "Sub Test:$subtest<br>";
}

else
{
	while($row1 = mysql_fetch_array($result2))
{
if(test =='$row1[Test]' && subtest == '$row1[subtest]')
{
print"Matched";
    }
    else
    {
    print("Not Matched");
    }
}	


}

}
}
}