Retrieve Session Value

[master82]

I have a session created that stores the username, how do I get this from the session and place it into a variable that I can use?

[code]
include("connect.php");

$sun = $_session['username'];

$sql = SELECT * FROM users WHERE username = $sun;
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
etc...
[/code]

This is what I currently have, (Session_start() already called earlier in the code), How can I retrieve the 'username' value and use it in my SQL query?

Thanks in advance

[ober]

$sun = $_SESSION['username'];

That should work (make sure you use CAPS). Remember that you must have put $_SESSION['username'] = 'some_value'; somewhere else in your code.

[master82]

I now get...

Unknown column '$sun' in 'where clause'

Sorry, put "" around the SELECT ----> $sun

then got...

Unknown column 'master82' in 'where clause'


(master82 being the stored value)

[master82]

Nevermind - placed '' around $sun in the query and I think its working

[ober]

Post again if you still have issues.