[SOLVED] sql update in php

[hasek522]

I am trying to create an update statement but cannot seem to get it to work.  If some one could take a look at it for me I would greatly appreciate it.

 

$sql = "UPDATE stylists SET

'firstname=". $firstname . "', 'lastname="

. $lastname. "', 'address="

. $address. "', 'city="

. $city. "', 'state="

. $state. "', 'zip="

. $zip. "', 'salon="

. $salon. "', 'specialty="

. $specialty. "', 'education="

. $education. "', 'experience="

. $experience. "', 'phone="

. $phone. "', 'email="

. $email. "', 'website="

. $website. "', 'description="

. $description . "' WHERE id=".$_SESSION['USERID'].")";

mysql_query($sql) or die(mysql_error());

[DarkWater]

Any errors?

[hasek522]

ya sorry, 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 ''firstname=Jason', ' lastname=Hedrick', ' address=4937 Briggs Ave', ' city=La Cr' at line 2

[Daniel0]

The query is completely malformed and the quotes are screwed up. Try to echo the query and you'll see what I mean.

[hasek522]

hmmm i echo'd it and kind of see what you mean, not exactly sure how to go about fixing it tho.

[Daniel0]

Just rewrite it:

 

$sql = "UPDATE stylists SET firstname='{$firstname}', lastname='{$lastname}', [...]";

[hasek522]

Ok heres my new statement :

 

$sql = "UPDATE stylists SET firstname='{$firstname}', lastname='{$lastname}', address='{$address}',

city='{$city}', $state='{$state}', zip='{$zip}', salon='{$salon}', specialty='{$specialty}',

education='{$education}', experience='{$experience}', phone='{$phone}', website='{$website}',

description='{$description}' WHERE id=".$_SESSION['USERID'];

 

Here is the error:

 

Unknown column 'California' in 'field list'

[hasek522]

nvm i fixed it.  Thanks all for the help.