Update two tables at once?

[ScoobyDooobyD00]

I'm trying to update two tables in the same database like this

$sql = "UPDATE table1 SET name = '$name'";
$res = mysql_query($sql) or die(mysql_error());

$sql2 = "UPDATE table2 SET row = '$row'";
$res2 = mysql_query($sql2) or die(mysql_error());

but it doesn't work. I've also looked at w3schools and tried this

$sql = "UPDATE table1, table2 SET table1.name = '$name' table2.row = '$row'";
$res = mysql_query($sql) or die(mysql_error());

Any ideas?

[mwasif]

Try this code

$sql = "UPDATE table1, table2 SET table1.name = '$name',
table2.row = '$row'"; 

[ScoobyDooobyD00]

Thank you that works except I forgot to mention how to would I get it to update a specific row? I've worked on it for about 10 minutes and can't get it to work.

This is what I mean

$sql = "UPDATE table1, table2 SET table1.name = '$name',
table2.row = '$row' WHERE table1.id = '$id' && table2.id = '$id'"; 

[ScoobyDooobyD00]

Ok thank you that worked!

But I still have one more question. How do I get it to update a specific row in those tables? like this

$sql = "UPDATE table1, table2 SET table1.name = '$name',
table2.row = '$row' WHERE table1.id = '$id' && table2.id = '$id'"; 

[laserlight]

Why do you have two tables instead of one table in the first place?

[mwasif]

You need to JOIN these tables with a common field to update a specific row.