[Resolved] Trouble with session variable and WHERE sql statement

Aesop

Hi,

I have a page where I need to show the users name from a table called users. Their name is stored under a column called real_name. I am also passing a session variable called user_name which is equivalent to their username they input to log into the system. When I try to use the code below, I get no errors however NOTHING shows up at all. Its just blank.

require '../globals/dbconnect.php';
$user_name = $_SESSION['user_name'];
$result = mysql_query("SELECT real_name FROM users WHERE real_name = '$user_name'");
//then call the query and display it
while ($row = mysql_fetch_array($result)) {
   printf("%s",  $row["real_name"]);

Now I'm pretty sure that my error is in the WHERE statement because I removed it and the $row will return a the first row from the real_name column. Suggestions?

thorpe

are you starting a session at the top of this script?

echo your session var to see if it has any content.

Aesop

sure am 🙂

Have been the whole time. Thats why this is so odd to me....

The session is active...

thorpe

did you echo it to see if it has a value? if so, is it a valid username?

Aesop

Sure did. it shows the correct user_name.

thorpe

got me beat then. sorry.

Aesop

Please allow me to put the dunce cap on my own head here....

require '../globals/dbconnect.php';
$user_name = $_SESSION['user_name'];
$result = mysql_query("SELECT real_name FROM users WHERE user_name = '$user_name'");
//then call the query and display it
while ($row = mysql_fetch_array($result)) {
   printf("%s",  $row["real_name"]);
   }

My query should have called for WHERE user_name = '$user_name' instead of WHERE real_name = '$user_name'. Funny how something that stresses you out for an hour only requires a 3 second fix......

:rolleyes: :p

thorpe

yeah.... hate that.