[SOLVED] Error

[Ashoar]

I am trying to get the Username from the current logged in user so that their name will be inserted into a database when making a post.

 

I am using this bit of code to query the database and match the session username.

$memberid="SELECT Username from Users WHERE Username = $_SESSION['Username']";

 

I get this error for that line above when i try to go to the php page containing it:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

 

What could be causing this?

[thebadbad]

You need to enclose the session variable (array) in curly brackets, when used inside a double quoted string:

 

$memberid="SELECT Username from Users WHERE Username = {$_SESSION['Username']}";

[Yesideez]

I would recommend this way:

$memberid="SELECT Username from Users WHERE Username = '".$_SESSION['Username']."'";

 

Notice I've also surrounded the session variable with single quotes.

 

Without them if the username had a space in it the query would become malformed and produce an error.

[Ashoar]

Ah my bad.

Thank you for pointing that out