Variable Trouble :(

[Stalingrad]

Hi. I'm programming a site, and for dome reason I can't get a variable to display.

 

I use sessions; and am logged in, but I can't seem to get a variable to show teh 'Credits" from the users table. It comes up black/as nothing.

Yes, the cedits row in the users table is there, and yes I have credits, (750).

 

How do I didplay the credits that the logged in user has to them?

 

I'm currently using:

 

$creditsqry = "SELECT credits FROM `users`

WHERE username='$username'";

 

$credits = mysql_query($creditsqry);

 

And display in: "$credits" as teh variable to display teh number of credits the user has for his/her account only.

 

Also; if it helps: $username = $_SESSION['username'];

 

 

May somebody please help me out? Thank You. ^^

[kenrbnsn]

After you do the mysql_query() you need to fetch the rows:

<?php
$creditsqry = "SELECT credits FROM `users` WHERE username='$username'";

$results = mysql_query($creditsqry) or die("Problem with the query: $creditsqry<br>" . mysql_error());
$rw = mysql_fetch_assoc($results);
$credits = $rw['credits'];
echo $credits;
?>

 

Ken

[Stalingrad]

Thank You.

 

It's still coming up blank. =/ I appreciate your help, though.