mysql query error

[phence]

i get an error on line one when trying to run this query

UPDATE users SET (first_name='$first', last_name='$last', apt_num='$apt', address1='$addy1', address2='$addy2', city='$city', state='$state', postalcode=$pos, country=$country, phone=$phone, email=$email) WHERE (username) = ('$userid');

whats wrong? it looks fine to me, the column names are correct.

[stolzyboy]

use single quotes around all your $variables, you don't need them with integers, but that way you don't have to worry about forgetting them, like $email should have them, probably country, etc...

are you getting any errors, use an or die(mysql_error()); to help you troubleshoot, etc...

[phence]

ahhh... my bad! i didn't realize i forgot them on the other ones
thanks aot

[phence]

hmm.... did i miss something else? still getting an error 🙁

UPDATE users SET (first_name='$first', last_name='$last', apt_num='$apt', address1='$addy1', address2='$addy2', city='$city', state='$state', postalcode='$pos', country='$country', phone='$phone', email='$email') WHERE (username) = ('$userid')

thank-you

[phence]

ya i am using or die(mysql_error(). it just says i have an error.. nothing specific...

[stolzyboy]

try using this

$query = "UPDATE users SET first_name = '$first', last_name = '$last', apt_num = '$apt', address1 = '$addy1', address2 = '$addy2', city = '$city', state = '$state', postalcode = '$pos', country = '$country', phone = '$phone', email = '$email' WHERE username = '$userid';";

then do

echo $query;

to ensure you have all the information in the query