On 5/5/05, Anasta <[EMAIL PROTECTED]> wrote:
> 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";

you should write

$sql = "Select user_balance  FROM users  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
> 
> 


-- 
bala> balachandar muruganantham
blog> lynx http://chandar.blogspot.com
web> http://www.chennaishopping.com

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

Reply via email to