[SOLVED] mysql session

[yogibear]

Hi

 

I have a mysql query and I want to use a session to select from the database WHERE username equals the contents of the session. Sorry if I have not been clear, I am finding it difficult to explain. My attempt at the code may make it easier to understand what I am trying to do.

 

$result = mysql_query("SELECT * FROM User
WHERE Username='$_SESSION["username"]'");

 

I have tried this code but I get an error.

 

Best wishes

yogi

[spasme]

id would help to see the error and the whole code.

 

first off, can you echo $_session['username']; ?

[sasa]

try

$result = mysql_query("SELECT * FROM User
WHERE Username='$_SESSION[username]'");

[discomatt]

try

$result = mysql_query("SELECT * FROM User
WHERE Username='$_SESSION[username]'");

 

More syntactically correct, but technically there's nothing wrong with your code

 

$result = mysql_query("SELECT * FROM User
WHERE Username='{$_SESSION['username']}'");

[yogibear]

Hi

 

Thanks for your help, it works perfectly now. Can I say that is some seriously fast response times, very impressive.

 

Best wishes

Yogi