PHP/MYSQL Help - unexpected T_VARIABLE

Question

I am trying to make a edit profile page and i want the user to be able to change there username and email address. I've been going at this problem now for sometime and need your help.

Parse error: syntax error, unexpected T_VARIABLE

$edit = mysql_query("UPDATE users (Username, EmailAddress) VALUES('".$newusername."', '".$newemail."') WHERE UserID="$_SESSION['UserID']"");

I suggest you read about string concatenation and arrays.

Felix Kling
– Felix Kling

2010-08-03 22:57:39 +00:00
Commented Aug 3, 2010 at 22:57 — Felix Kling
– Felix Kling, Commented Aug 3, 2010 at 22:57

Marek Karbarz · Accepted Answer · 2010-08-03 22:49:51Z

4

you're missing some dots around $_SESSION['UserID']

$edit = mysql_query("UPDATE users (Username, EmailAddress) VALUES('".$newusername."', '".$newemail."') WHERE UserID=" . $_SESSION['UserID']);

answered Aug 3, 2010 at 22:49

Marek Karbarz

29.4k6 gold badges55 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ritch Over a year ago

Thanks, I'm not getting "Parse error: syntax error, unexpected '['"

Felix Kling Over a year ago

@ritch: Please read Marek's answer carefully. You didn't use his code. I suggest you read about string concatenation and arrays.

NikiC Over a year ago

@ritch: You must move the dot after $_SESSION after ['UserID'] so you have UserID = ".$_SESSION['UserID']."". And as Marek wrote, you may omit concating the empty string, so you have: UserID = ".$_SESSION['UserID'].

Collectives™ on Stack Overflow

PHP/MYSQL Help - unexpected T_VARIABLE

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related