Сортиране по Kills, добавяне на "id"

C

cmsfan

Registered
Имам този код:

Код: 
    <center>
    <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; text-align: center;" width="100%">
    <tr style="color:black;border-top: 1px solid #FB7A31;border-bottom: 1px solid #FB7A31;background: #FFC;">
    <td>#</td>
    <td>Ник</td>
    <td>Убийства</td>
    <td>Умирания</td>
    <td>Глави</td>
    <td>C4 Залагания</td>
    <td>C4 Обезвреждания</td></tr>
    <?php
    $connect = mysql_connect("localhost", "potrebitel", "parola") or die(mysql_error());
    mysql_select_db("ime na db", $connect) or die(mysql_error());
    $br = 15;
    $pageNum = 1;
    if(isset($_GET['page'])) {
    $pageNum = (int)$_GET['page'];
    $pageNum = ($pageNum)?$pageNum:1;
    }
    $redove = ($pageNum - 1) * $br;
    $result = mysql_query("SELECT * FROM `players` ORDER BY id LIMIT $redove, $br")or die(mysql_error());
    while($row = mysql_fetch_array($result)) {
    $row = str_replace("<", "<", $row);
    $row = str_replace(">", ">", $row);
    echo "<tr>
    <td style='color:#ccc;border-bottom: 1px solid #cccccc;padding: 5px;'>$row[id]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[player_name]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[kills]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[deaths]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[headshot_kills]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[planted_bombs]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[defused_bombs]</td>
    </tr>";
    }
    $query = mysql_query("SELECT COUNT(id) AS numrows FROM players") or die(mysql_error());
    $row = mysql_fetch_array($query, MYSQL_ASSOC);
    $numrows = $row['numrows'];
    $maxPage = ceil($numrows/$br);
    $ns = '</table>
    Статистиката се занулява всеки Петък от 10:00 PM</center><br /><center>Страници: ';
    for($page = 1; $page <= $maxPage; $page++) {
    if ($page == $pageNum) {
    $ns .= " <a class=\"typ1noh\" style=\"color: #ffffff\">$page</a> ";
    }
    else {
    $ns .= "<a class=\"typ1\" href=\"?a=meele&page=$page\">$page</a> ";
    }}
    if ($pageNum > 1) {
    $page = $pageNum - 1;
    $pr = " <a href=\"?a=meele&page=$page\"></a> ";
    $one = " <a href=\"?a=meele&page=1\"></a> ";
    }
    else {
    $pr = ' ';
    $one = ' ';
    }
    if ($pageNum < $maxPage) {
    $page = $pageNum + 1;
    $sl = (" <a href=\"?a=meele&page=$page\"></a> ");
    $pl = (" <a href=\"?a=meele&page=$maxPage\"></a> ");
    }
    else {
    $sl = '';
    $pl = '';
    }
    echo $one . $pr . $ns . $sl . $pl;
    ?>
    </center>

В момента е Order by id, обаче като е по Kills не показва на първите примерно, че са на позиция "1", а на "53" (каквото е id-то на записа)
Въпроса ми е как да ги сортирам по kills, но да ги вади така:
1
2
3
4
5
6
А не примерно:
53
16
33
и т.н.
(Надявам се да сте ме разбрали)
 
Не става по-този начин.
Приемам и някаква функция, примерно в която има 1 и постоянно и се задава +1 оттам нататък (дали с php или с jquery - няма значение)
 
PHP: 
    <center>
    <table cellpadding="0" cellspacing="0" style="border-collapse: collapse; text-align: center;" width="100%">
    <tr style="color:black;border-top: 1px solid #FB7A31;border-bottom: 1px solid #FB7A31;background: #FFC;">
    <td>#</td>
    <td>Ник</td>
    <td>Убийства</td>
    <td>Умирания</td>
    <td>Глави</td>
    <td>C4 Залагания</td>
    <td>C4 Обезвреждания</td></tr>
    <?php
    $connect = mysql_connect("localhost", "potrebitel", "parola") or die(mysql_error());
    mysql_select_db("ime na db", $connect) or die(mysql_error());
    $br = 15;
    $pageNum = 1;
    if(isset($_GET['page'])) {
    $pageNum = (int)$_GET['page'];
    $pageNum = ($pageNum)?$pageNum:1;
    }
    $redove = ($pageNum - 1) * $br;
    $result = mysql_query("SELECT * FROM `players` ORDER BY `kills` DESC LIMIT $redove, $br")or die(mysql_error());
	$i='';
    while($row = mysql_fetch_array($result)) {
	$i++;
    $row = str_replace("<", "<", $row);
    $row = str_replace(">", ">", $row);
    echo "<tr>
    <td style='color:#ccc;border-bottom: 1px solid #cccccc;padding: 5px;'>{$i}</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[player_name]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[kills]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[deaths]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[headshot_kills]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[planted_bombs]</td>
    <td style='color:#ccc;border-bottom: 1px solid #CCCCCC;border-left: 1px solid #CCCCCC;padding: 5px;'>$row[defused_bombs]</td>
    </tr>";
    }
	$i='';
    $query = mysql_query("SELECT COUNT(id) AS numrows FROM players") or die(mysql_error());
    $row = mysql_fetch_array($query, MYSQL_ASSOC);
    $numrows = $row['numrows'];
    $maxPage = ceil($numrows/$br);
    $ns = '</table>
    Статистиката се занулява всеки Петък от 10:00 PM</center><br /><center>Страници: ';
    for($page = 1; $page <= $maxPage; $page++) {
    if ($page == $pageNum) {
    $ns .= " <a class=\"typ1noh\" style=\"color: #ffffff\">$page</a> ";
    }
    else {
    $ns .= "<a class=\"typ1\" href=\"?a=meele&page=$page\">$page</a> ";
    }}
    if ($pageNum > 1) {
    $page = $pageNum - 1;
    $pr = " <a href=\"?a=meele&page=$page\"></a> ";
    $one = " <a href=\"?a=meele&page=1\"></a> ";
    }
    else {
    $pr = ' ';
    $one = ' ';
    }
    if ($pageNum < $maxPage) {
    $page = $pageNum + 1;
    $sl = (" <a href=\"?a=meele&page=$page\"></a> ");
    $pl = (" <a href=\"?a=meele&page=$maxPage\"></a> ");
    }
    else {
    $sl = '';
    $pl = '';
    }
    echo $one . $pr . $ns . $sl . $pl;
    ?>
    </center>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе