UPDATE syntax error

[rapmonkey]

When this code is run:

mysql_query("UPDATE " . $prefix . "members SET realname = '$realname', displayname = '$displayname', pw = '$pwform', icon_url = '$icon_url', email = '$email', aim_id = '$aim_id', msn_id = '$msn_id', yahoo_id = '$yahoo_id', icq_id = '$icq_id', homepage = '$homepage', homepage_link = '$homepage_link, birthdate = '$birthdate', location = '$location', timediff = '$timediff', signature = '$signature' WHERE memberid='$memberid'", $connection) OR DIE("Gravity Board X was unable to update your profile: " . mysql_error());

I get the error: Gravity Board X was unable to update your profile: You have an error in your SQL syntax near '1'' at line 1

I can't figure out what's wrong. Any help is appreciated. 😃

[DeltaRho2K]

Can you repost using about the first 10 lines of your PHP as you have it coded? Also, post the form code you are using to post this data to begin with.

[acidbox]

can u post a sample query that would result from this string?

ie: print($sql);

[rapmonkey]

I'm 100% positive the form is sending the script the info using the correct variable names. And in this case, $memberid is equal to 1.

[rapmonkey]

Thanks for the help, but I got it... I ran over the code again and I was missing a '

[batman]

You are missing a ' after homepage link.

-Blake