Multiple tables update PROBLEM!

[mak1e]

//can anybody help me with this, i've already tried
//this but it doesn't work on me..

//Problems on the FF platform:
//apache on win2k, PHP4.3.1, MySQL v3.23.51
//sambar on win2k, PHP4.1.2, MySQL v3.23.47

// update user and profiles table to mysample database.
/*

---

users UPDATE
*/

$sql = "UPDATE users,profiles SET ";
$sql .= " users.email = \"" . $email . "\"";
$sql .= " users.pref = \"" . $pref . "\"";
$sql .= " users.birthdate = \"" . $birthdate . "\"";
$sql .= " users.country = \"" . $country . "\"";
$sql .= " users.city = \"" . $city . "\"";
$sql .= " users.relationship_type = \"" . $relationship_type . "\"";

/*

---

profiles UPDATE
*/
$sql .= " profiles.height = \"" . $height . "\"";
$sql .= " profiles.appear = \"" . $appear . "\"";
$sql .= " profiles.built = \"" . $built . "\"";
$sql .= " profiles.race = \"" . $race . "\"";
$sql .= " profiles.feature = \"" . $feature . "\"";

[kevinsequeira]

First of all you need to have MySQL Version > 4.0.4, to do updates on mulitple tables and secondly in your syntax you are missing the , after each column value, and i assume you have a WHERE condition at the end else it will update all rows

// update user and profiles table to mysample database.
/*
***********
users UPDATE
*/


$sql = "UPDATE users,profiles SET ";
$sql .= " users.email = '" . $email . "'";
$sql .= " ,users.pref = '" . $pref . "'";
$sql .= " ,users.birthdate = '" . $birthdate . "'";
$sql .= " ,users.country = '" . $country . "'";
$sql .= " ,users.city = '" . $city . "'";
$sql .= " ,users.relationship_type = '" . $relationship_type . "'";

/*
***********
profiles UPDATE
*/
$sql .= " ,profiles.height = '" . $height . "'";
$sql .= " ,profiles.appear = '" . $appear . "'";
$sql .= " ,profiles.built = '" . $built . "'";
$sql .= " ,profiles.race = '" . $race . "'";
$sql .= " ,profiles.feature = '" . $feature . "'";

reg
kevin