select statement
| From: | Anasta | Date: | Thu, 05 May 2005 08:10:35 +0000 |
| Subject: | select statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-214491@lists.php.net to get a copy of this message | ||
Why doesnt this work, it shows the username but not the balance of the users
money.here is the mysql table:
CREATE TABLE
users (
user_id int(11) NOT NULL auto_increment,
username varchar(15) NOT NULL default '',
password varchar(15) NOT NULL default '',
status varchar(10) NOT NULL default '',
user_balance bigint(5) NOT NULL default '0',
PRIMARY KEY (user_id)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
/////////////////////////////////////////////////////////
<?php session_start();
include("connect.php");
$uname=$_SESSION['username'];
$user_balance=mysql_query($sql);
$sql = "Select FROM users ,user_balance WHERE user_id =$uname";
$result = mysql_query();
?>
<?php echo $uname;?><br>
<?php echo $user_balance;?>