Update Multiple Tables in MYSQL using PHP

quad

I know this can be done, but how? hee is the error i am receiving and also a example update statement:

I consistently get the following error:

SQL Exception error #1064, Resphonse from the database:

You have an error in your SQL syntax near 'person

set person.first_name = 'Bob',
phone.phone_no = '5551212'

w' at line 1

******** SQL Statement *****
UPDATE phone, person, address set
peson.first_name = 'John',
phone.phone_no = '1234567890'
address.state_cd = 'FL'

where person.person_id = phone.person_person_id
and person.person_id = address.person_person_id
and person.person_person_id = '4';

Any thoughts or suggestions on why this doesnt work?

I have the eqivalent in PHP code adn get the same error.

leatherback

for sure the typo doesn't help:

peson.first_name

should be:

person.first_name ??

quad

Here is what I decided to use, also gives some flexibility for maintaing the code line. Hope this helps for those who are having problems......

Here we go: (Remember this is a hack for mysql v. < 4.1!!1)

***declared personID as a variable in earlier code.

$sql_up_person = "UPDATE person SET
person.first_name = '$REQUEST[firstname]',
person.last_name = '$REQUEST[lastname]',
person.email = '$_REQUEST[email]'
where person.person_id = '$personID'";

$sql_up_phone = "UPDATE phone SET
phone.phone_no = '$_REQUEST[phoneno]'
where phone.person_person_id = '$personID'";

$sql_up_address = "UPDATE address SET
address.addr_line_1 = '$_REQUEST[addressline1]',
address.addr_line_2 = '$_REQUEST[addressline2]',
address.city = '$_REQUEST[city]',
address.state_cd = '$_REQUEST[staecd]',
address.zip = '$_REQUEST[zip]'
where address.person_person_id = '$personID'";

echo("<p>person id is : " . $sql_update . "</p>");

/*
**** This is a hack for mysql v. < 4.1. The early versions do not allow
**** for multiple table updates at one time, so I put in this hack.
**** IV
*/
$result = mysql_query($sql_up_person, $conn);
$result = mysql_query($sql_up_phone, $conn);
$result = mysql_query($sql_up_address, $conn);