high scores table

[martinjamesroberts]

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"; }

?>

[Zurev]

$recept = SelectDatas($table, "name, score, dategame", "id > 0", "score desc");

 

to...

 

$recept = SelectDatas($table, "name, score, dategame", "id > 0", "score asc");

 

[martinjamesroberts]

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.