Table Synchronization

Deleting fields from one list where they exist in another...

[inveni0]

I'm trying to write a deletion script that will delete all fields from Table A that exist in Table B. I'm trying:

do {

$Exists = $row_BnBs['EMail'];
if ((isset($_GET['EMail'])) && ($_GET['EMail']!= "")) {
$deleteSQL = sprintf("DELETE FROM SalesList WHERE EMail=$Exists";
mysql_select_db($database_EditData, $EditData);
$Result1 = mysql_query($deleteSQL, $EditData) or die(mysql_error());

} while ($row_SalesList = mysql_fetch_assoc($SalesList));

This is not working. Is there another way to force this script to loop? Or, is there simply something wrong with the script I have?

[inveni0]

There was a missing ')' in that code. I fixed the typo, but it didn't help the script.

I've simplified the script to:

do {

$Exists = $row_BnBs['EMail'];

mysql_query("DELETE FROM SalesList WHERE EMail='$Exists'") or die(mysql_error());

} while ($row_SalesList = mysql_fetch_assoc($SalesList));

I'm still getting no response.

[inveni0]

I solved it. I had to change the 'while' statement.

I used:

//Begin Deletion Cycle

do {

$Exists = $row_BnBs['EMail'];

mysql_query("DELETE FROM SalesList WHERE EMail='$Exists'") or die(mysql_error());

} while ($row_BnBs = mysql_fetch_assoc($BnBs));

[coopster]

Which version of MySQL are you running there?

[inveni0]

4.0.13

Why?

[coopster]

As of MySQL 4.1 you could have run a subquery instead of one query, then another. But your workaround is your best bet for now.