[SOLVED] how do i show users gold?

[berry05]

i have this code now..

<?php 

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("textgame") or die(mysql_error());

 $result = mysql_query("SELECT * FROM users WHERE username='$Username'") 
or die(mysql_error()); 

$row = mysql_fetch_array( $result );
echo $row['gold'];


?>

 

to show the users gold but i get no errors and it doesnt show the gold though...when i get rid of usernames= $usernames thing it shows the gold for the first user in the row though..

plz help!

 

 

thxs!

[.josh]

I don't see anywhere in that code where you are assigning anything to $Username

[berry05]

on the top of the whole script theres this..

<?php
session_start();
if(isset($_SESSION['Username'])){
?>

 

if that would be it?

[timmah1]

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

[redarrow]

<?php session_start();

if(isset($_SESSION['Username'])){

$db=mysql_connect('localhost', 'root', 'password');

$res=mysql_select_db('textgame',$db) or die(mysql_error());

    
$sql = "SELECT * FROM users WHERE username='".$_SESSION['Username']."'"; 
    
    $res=mysql_query($sql)or die(mysql_error());
    
  
    while($row = mysql_fetch_assoc($res)){


  	echo $row['gold'];
  
  }
}else{

echo "Sorry your not a member please join us!";
}
?>

[berry05]

thank you guys!!

redarrow...what did you do to fix the problem?