Join Problem

[cbrknight]

I am using the following code to check a join for duplicate records...

//csv is not empty and work insert matched csv so check for duplicates
$sql2 = "SELECT * FROM users_working INNER JOIN users ON users_working.validation=users.validation";
$r2 = mysql_query($sql2, $importer)or die("ERROR: ".mysql_error());
$c2 = mysql_num_rows($r2);
echo "<br>Duplicate records:". $c2;
 if ($c1 == $c2){
echo ("<br>Duplicate Batch!! <br />" . $c2 . " records already in database");

Right now it stops the import. What i need to do is to update the existing record instead of stopping the import. Can someone help me with this. I am using PHP4

Thanks

[konsu]

what does "stops import" mean? could you rephrase the question so i can understand what it is about?

[cbrknight]

when the conditions of the statement are true... ie... there is a record in the maintable that matches the record in the working table.

it stops and displays The Error Message

The number of duplicate records

And a Message that there are duplicate records in the import.

What I need it to do is to update the existing record when it is found, display a message that # of records were updated... and continue to run the rest of the code....

[konsu]

try something like

update table ... where id in (select id from table0 inner join table1 ...)

Makes sense?