Mysql Problem
Posted: Wed Mar 02, 2005 5:56 pm
Well, I'm working on a text-based game, and for a top ten list, I need to get the players with the most gold. Using the following code, I want to add the player's bank gold and gold together. But it ends up with this:
1 - cbrian (4,364,664,514g)
2 - ikki (8,581,934,390g)
3 - Ecko (8,581,935,340g)
... and the rest is fine.
Code:
1 - cbrian (4,364,664,514g)
2 - ikki (8,581,934,390g)
3 - Ecko (8,581,935,340g)
... and the rest is fine.
Code:
Code: Select all
$query = mysql_query("SELECT * FROM users ORDER BY 'bank_gold'+'gold' DESC");