Jump to content

Echoing From Database


dean7

Recommended Posts

Hi all, On my website I have a Functions file which holds information about the user for the game, but earier on today I added ranks which are for the users money. So for the ammout of money they have gives them a different money rank.

 

Heres what ive got:

 

function wealthrank(){
if (($info->money >= "0") && ($info->money < "10000")){ $wealth = "Poor (£0 - £10,000)"; $done="1"; }
elseif (($info->money >= "10000") && ($info->money < "500000")){ $wealth = "Won The Lottery (£10,000- £500,000)"; $done="1"; }
elseif (($info->money >= "500000") && ($info->money < "5000000")){ $wealth = "Too Much (£500,000 - £5,000,000)"; $done="1"; }
elseif (($info->money >= "5000000") && ($info->money < "20000000")){ $wealth = "Millionare (£5,000,000 - £20,000,000)"; $done="1"; }
elseif (($info->money >= "20000000") && ($info->money < "75000000")){ $wealth = "Owns The Streets (£20,000,000 - £75,000,000)"; $done="1"; }
elseif (($info->money >= "75000000") && ($info->money < "100000000")){ $wealth = "Won The Euro Millions (£75,000,000 - £100,000,000)"; $done="1"; }
elseif (($info->money >= "100000000") && ($info->money < "300000000")){ $wealth = "Multi millionare (£100,000,000 - £300,000,000)"; $done="1"; }
elseif (($info->money >= "300000000") && ($info->money < "700000000")){ $wealth = "Owns A Bank (£300,000,000 - £700,000,000)"; $done="1"; }
elseif (($info->money >= "700000000") && ($info->money < "1500000000")){ $wealth = "Rather Rich (£700,000,000 - £1,500,000,000)"; $done="1"; }
elseif (($info->money >= "1500000000") && ($info->money < "5000000000")){ $wealth = "Billionare (£1,500,000,000  - £5,000,000,000)"; $done="1"; }
elseif (($info->money >= "5000000000") && ($info->money < "70000000000")){ $wealth = "Owner Of The Land (£5,000,000,000 +)"; $done="1"; }
elseif ($info->money >= "100000000000"){ $wealth = "Nearly As Rich As NoName (Hidden!)"; $done="1"; }

if (!$done){
$done="0";
}
if ($done == "1"){

mysql_query("UPDATE users SET wealthrank='$wealth' WHERE username='$username'");
}}
wealthrank();

 

For some reason its not echoing the correct wealth rank, even at that its only echoing the defult wealth rank.

 

Here is what I done to test it.

<?php
session_start();
include ("includes/functions.php");
include ("includes/config.php");
logincheck();

$username = $_SESSION['username'];

$get = mysql_query ("SELECT * FROM users WHERE username='$username'");
$fetch = mysql_fetch_object($get);
?>
Testing something: 

<?php echo ($username); ?><br />

Wealth Rank: <?php echo ($fetch->wealthrank); ?><br />

 

Is there something wrong with the way im fetching it from the Database or something wrong with the code?

 

Thanks for any help given. :)

Link to comment
https://forums.phpfreaks.com/topic/216713-echoing-from-database/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.