dean7 Posted October 24, 2010 Share Posted October 24, 2010 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.