martinjamesroberts Posted December 13, 2010 Share Posted December 13, 2010 Hello, I have what I hope to be a very simple question.. I have built a game in flash and for my high score table I simply want to request the high scores in reverse.. i.e the lowest score first.. here is my php.. please help, thanks in advance !! :- <?php include("sqldialog.php"); $table = $_POST['tab']; $recept = SelectDatas($table, "name, score, dategame", "id > 0", "score desc"); if ($recept) { $i = 0; foreach ($recept as $rec) { $i++; if ($i==1) { $result .= "pseudo$i=".$rec['name']."&score$i=".$rec['score']."&dategame$i=".$rec['dategame']; } else { $result .= "&pseudo$i=".$rec['name']."&score$i=".$rec['score']."&dategame$i=".$rec['dategame']; } } echo $result; } else { echo "BAD, $pseudo, $score, $dategame,$ipclient"; } ?> Link to comment https://forums.phpfreaks.com/topic/221526-high-scores-table/ Share on other sites More sharing options...
Zurev Posted December 13, 2010 Share Posted December 13, 2010 $recept = SelectDatas($table, "name, score, dategame", "id > 0", "score desc"); to... $recept = SelectDatas($table, "name, score, dategame", "id > 0", "score asc"); Link to comment https://forums.phpfreaks.com/topic/221526-high-scores-table/#findComment-1146728 Share on other sites More sharing options...
martinjamesroberts Posted December 13, 2010 Author Share Posted December 13, 2010 I'll change this first thing tomorrow.. I'm sure it'll be fine, seems simple enough.. I'll remember to mark it solved once I've verified. Many Thanks for your help. Link to comment https://forums.phpfreaks.com/topic/221526-high-scores-table/#findComment-1146735 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.