[RESOLVED] Join

[benracer]

Hi,
I have two tables, one backup and one items.

Each one contains an id.

In both there is a column called name. How can i replace the name in items with the one in backup?

Thanks

[benracer]

Sorted It,

<?php
include("connection.php");

$sql = mysql_query("SELECT * FROM backup");

while($b = mysql_fetch_array($sql)){ 
$name = $b['name'];
$id = $b['id'];
echo $name . "<br>";
mysql_query("UPDATE items SET name='$name' WHERE id='$id'");
}
?>

[laserlight]

Actually, you probably could write:

<?php
include 'connection.php';

mysql_query("UPDATE items, backup SET items.name=backup.name WHERE items.id=backup.id");
?>

This would be more efficient than executing updates in a loop, especially since you do not wrap the updates in a transaction. From what I understand, it would also avoid a race condition.