PHP, Fetching highscores, how it works?

[slavi]

Hello Guys
___________:

I was wondering to create something new

But i stopped at a point, fetching high-scores is not working so good, but it don't sort them.

so i wish someone helps me making a script.

The script I am using is :

<?php
    include 'connect.php';
   
    $query = "SELECT level FROM `players`;";
    $result = mysql_query($query, $connection);
    $nexterrow = mysql_num_rows($result);
    if($nexterrow) {
        echo '<table cellpadding="0" cellspacing="0" class="db-table">';
        sort($nexterrow);
        while($row = mysql_fetch_row($result)) {
            echo '<tr>';
            foreach($row as $key=>$value) {
                echo '<td>'.$value.'</td>';
            }
            echo '</tr>';
        }
        echo '</table><br />';
    }
?>

 

[raf]

And what's wrong ?

If the problem is sorting, just change your query to:

$query = "SELECT level FROM `players` ORDER BY level DESC;";

or

$query = "SELECT level FROM `players` ORDER BY level ASC;";

--side note

Is lastdeath some kind of AAC engine ?

 

[slavi]

If the problem is sorting, just change your query to:

$query = "SELECT level FROM `players` ORDER BY level DESC;";

Thanks for your replying, it worked well.

Is lastdeath some kind of AAC engine ?

It's called --daydream and ye it's new aac done by me, maybe i release when i complete it and check it, ( Iam 90 % done)