wheres the error?

[hoponhiggo]

Hi Guys

 

Can anybody tell me where the "Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in " is in this peice of code

 

$get = mysql_query( "SELECT * FROM `friend_requests` WHERE 'username' = `$_SESSION['MM_Username']`"); 

 

if i shorten this to

 

$get = mysql_query( "SELECT * FROM `friend_requests`");

 

It works fine, so im guesing the error is somewhere in

 

WHERE 'username' = `$_SESSION['MM_Username']`"); 

 

Thanks

[PFMaBiSmAd]

Php array variables inside of a double-quoted string need to be enclosed by {}, i.e. {$_SESSION['MM_Username']}

 

Your query also has two sql syntax problems. Your username column is enclosed by single-quotes, making it a string instead of a column identifier and your $_SESSION['MM_Username'] value is enclosed by back-ticks ``, causing it to be treated as a column identifier. The $_SESSION['MM_Username'] value, which is a string data value, should be enclosed by single-quotes. Back-ticks are mysql specific and should be avoided whenever possible (you only need them when a database, table, or column name contains special characters or is a reserved mysql keyword.)

 

With all the changes -

 

$get = mysql_query( "SELECT * FROM friend_requests WHERE username = '{$_SESSION['MM_Username']}'"); 

 

 

[hoponhiggo]

aah...I see. Thank you very much