 |
 |
Find a programming school near you
php-general | 2005051
Date: 05/05/05
- Next message: Jon M.: "[PHP] Re: Thanks, I understand now"
- Previous message: Ross: "[PHP] insert not working"
- In reply to: Anasta: "[PHP] select statement"
- Next in thread: Prathaban Mookiah: "Re: [PHP] select statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On 5/5/05, Anasta <neretlis <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
- Next message: Jon M.: "[PHP] Re: Thanks, I understand now"
- Previous message: Ross: "[PHP] insert not working"
- In reply to: Anasta: "[PHP] select statement"
- Next in thread: Prathaban Mookiah: "Re: [PHP] select statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
