IF Statement?

[efc_90]

Hey guys,

I have the following queries:

$query = "SELECT * from Bank";
$result1 = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result1)){
$bank_ID = $row['bank_ID'];
$bank_date = $row['Date'];
$bank_amount = $row['Amount'];
}

$intranet_query = "SELECT * from Intranet";
$result2 = mysql_query($intranet_query) or die (mysql_error());
while ($row = mysql_fetch_array($result2)) {
$intranet_ID = $row['intranet_ID'];
$intranet_store = $row['Store'];
$intranet_amount = $row['Amount'];
}

I want to select the amounts and ID's from both tables.. but only if the Amounts from each record DONT match.

Does anyone know how i would go about doing this? I know it's some form of if statement, but I dont get how I would input the data.

Cheers

[sfullman]

you're going to need to do some type of comparison. I suggest something like this, and this is very much abbreviated:

$result1 = mysql_query($bankquery) or die(mysql_error());
$result2 = mysql_query($intranetquery) or die(mysql_error());
/* note: what I'm writing is DANGEROUS unless you first verify that the count is the same!!!!  Also you must sort by the same index, which I don't know what that is */
while($row1 = mysql_fetch_array($result1)) {
   $row2=mysql_fetch_array($result2);
  //now compare row1 and row2, and store in some type of separate array..
}