error in update statement. can anyone tell me what is wrong?

[ellegua220]

There is an error in this update statement.  Here is the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user.userid = 209 set user.username='ttttt', email='[email protected]', fir' at line 1

here is the code:

$query = sprintf("UPDATE user LEFT JOIN parent_user ON parent_user.userid = user.userid LEFT JOIN parent ON parent.parent_id = parent_user.parent_id WHERE user.userid = $userid set user.username='$username', email='$email', first_name='$first_name', last_name='$last_name', password='$password',phone='$phone', street_address='$street_address', other_address='$other_address', city='$city', state='$state', zipcode='$zipcode', type='$type', school='$school', school_district='$school_district',double_gui='$double_gui',status_id=$status_id,notes='%s',parent.parent_first_name='$parent_first_name',parent.parent_last_name='$parent_last_name' where userid=$userid", mysql_real_escape_string($notes, $mysql_link));

[ellegua220]

the where clause was out of place i think??

[kickstart]

Hi

 

You appear to have 2 separate where clauses.

 

All the best

 

Keith

[fenway]

And SET needs to come earlier in the syntax.

[kickstart]

And SET needs to come earlier in the syntax.

 

Depends which of the wheres are deleted .

 

All the best

 

Keith