What's wrong here? 1

[shamrox]

Can someone tell me what's wrong with this line of code. It's giving me a parse error of T_CONSTANT_ENCAPSED_STRING

$query_rs_username = "SELECT employees.name FROM employees WHERE employees.username = ".$_SESSION['MM_Username']"";

http://www.metrodesignworks.com

http://www.nowthatsodd.com/deadpool/

 

[Chacalinc]

.$_SESSION['MM_Username']"";

escape it:

$query_rs_username = "SELECT employees.name FROM employees WHERE employees.username = ".$_SESSION['MM_Username']\"";

 

[Chacalinc]

again, to note it good:
$query_rs_username = "SELECT employees.name FROM employees WHERE employees.username = ".$_SESSION['MM_Username'][COLOR=red yellow] \" [/color]";

 

[Chacalinc]

again, to note it good:

$query_rs_username = "SELECT employees.name FROM employees WHERE employees.username =[COLOR=red yellow] ' ".$_SESSION['MM_Username'] ."'";[/color]

 

[danomac]

there is also a concatenation . missing after your $_SESSION[] variable

$query_rs_username = "SELECT employees.name FROM employees WHERE employees.username = \"" . $_SESSION['MM_Username'] . "\"";

That should work.

 

[shamrox]

You Rock!!!! Thanks.

http://www.metrodesignworks.com

http://www.nowthatsodd.com/deadpool/

 

[danomac]

Sorry Chacalinc, we must've been viewing it at the same time...

 

[Chacalinc]

it's ok danomac... anyway, we both get the same hit