Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2005051

[PHP] select statement From: Anasta (neretlis <email protected>)
Date: 05/05/05

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;?> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php