Session Question - Fetch User Rows/Tables?

[andreasb]

Hello,

 

Right now I'm having a hard time fetching rows via sessions.

 

Let's say that I have a session:

$_SESSION['username']

Now I log in with username "Andreas".

Now I want to fetch the my "Points" count. It looks like this:

 

How can I fetch that info by using my USERNAME session?

[teamatomic]

$username=$_SESSION['username'];

SELECT * FROM users WHERE username= $username

 

HTH

Teamatomic

[jl5501]

more specifically

 

"SELECT * FROM users WHERE username= '$username'"

[andreasb]

And how exactly will this make me able to do this?

echo $points;

 

This did not work, and I'm not sure how to use your replies for what I want to do.

$username = $_SESSION['username'];
$points = "SELECT * FROM members WHERE username=$username";

[Dennis1986]

Maybe you should read this:

http://www.w3schools.com/PHP/php_mysql_where.asp

[jl5501]

you must have your $username in its own quotes

[andreasb]

you must have your $username in its own quotes

 

That solved everything! Thanks bunch !