Check duplicate numbers from two tables

[cow]

Hello to all,

 

I have two database tables, which in the first row both contain numbers. I want to use php to find out which numbers from the 2nd table (let's name it k34) is found in the first (that one we will name report) and which numbers are not found in there.

 

Can some one give me any clues?

 

Thank you in advanced.

[Garethp]

$k34q = mysql_query("SELECT * FROM k34");

$i = 0;
while($Look = mysql_fetch_array($k43q))
{
$k43[$i] = $Look['ColumnName'];
$i ++;
}

$Reportq = mysql_query("SELECT * FROM Report");

$i = 0;
while($Look = mysql_fetch_array($Reportq))
{
$Report[$i] = $Look['ColumnName'];
$i ++;
}

$e = 0;
$j = 0;

foreach ($k34 as $v)
{
$i = 0;
foreach($Report as $k)
	{
	if($k == $v)
		{
		$i = 1;
		}
	}

if($i == 1)
	{
	$Found[$e] = $v;
	$e ++;
	}
else
	{
	$Lost[$j] = $v;
	$j ++;
	}
}
echo "Found:<br>";
foreach ($Found as $v)
{
echo $v . "<br>";
}

echo "<br><br>Lost:<br>";
foreach ($Lost as $v)
{
echo $v . "<br>";
}

 

Simple, long and unoptimized, but it will do

[cow]

Will try it later and let you know... Thx by the way