A
Anonymous
Guest
Добър ден! Абе правя си аз една система, в която е нужно и класиране. Пиша си кода, няма никакъв проблем, освен един. Направил съм "DESC" LIMIT, обаче не ми ги класира от най-много до най-малко. Ето кодът:
Код:
<?php
mysql_connect('localhost', 'дсфдсфдс' , 'фдсфдс') or die ('NO SERVER');
mysql_select_db('сдфдсфдс') or die ('NO DATA BSE');
///////////////////////////////////////////////
$tableName = "users";
$limit = 15;
$orderby="tochki";
$stages = 1;
$start = 0;
$query = "SELECT COUNT(*) as num FROM $tableName";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
$page = mysql_escape_string($_GET['page']);
if ($page) {
$start = ($page - 1) * $limit;
} else {
$start = 0;
}
// Get page data
$query1 = "SELECT * FROM $tableName WHERE vip=`0` order by tochki DESC LIMIT 0, 15";
$result = mysql_query($query1);
$rq = mysql_query("SELECT * FROM `users` WHERE vip=0 ORDER BY tochki DESC limit 0, 15");
while($data = mysql_fetch_assoc($rq)) {
if(!(file_exists("avatars/$data[username].gif")))//Checks if there is an avatar
{
$avatar = "<img src=\"avatars/noavatar.gif\" width=70 height=60 />";
}
else
{
$avatar = "<img src=\"avatars/$data[username].gif\" width=70 height=60/>";
}
echo "<td class=\"kef-body\" > <a class=\"tooltip\" href=\"$data[username]\">$data[username] <span class=\"classic\"> <div style=\"margin-left: -40px;\"> $avatar</div> Юзър: $data[username] <br> Долари: $data[tochki]</span> </a> </td>
<td class=\"kef-body\" > $data[tochki] </td>
<td class=\"kef-body\"> <a href=\"vote.php?id=$data[id]\">Дай глас бе!</a></td><tr />";
}
// Initial page num setup
if ($page == 0) {
$page = 1;
}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages / $limit);
$LastPagem1 = $lastpage - 1;
$paginate = '';
if ($lastpage > 1) {
$paginate .= "<div class='paginate'>";
// Previous
if ($page > 1) {
$paginate.= "<a href='$targetpage?page=$prev'><<</a>";
} else {
$paginate.= "<span class='disabled'><<</span>";
}
// Pages
if ($lastpage < 7 + ($stages * 2)) { // Not enough pages to breaking it up
for ($counter = 1; $counter <= $lastpage; $counter++) {
if ($counter == $page) {
$paginate.= "<span class='current'>$counter</span>";
} else {
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
}
}
} elseif ($lastpage > 5 + ($stages * 2)) { // Enough pages to hide a few?
// Beginning only hide later pages
if ($page < 1 + ($stages * 2)) {
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) {
if ($counter == $page) {
$paginate.= "<span class='current'>$counter</span>";
} else {
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// Middle hide some front and some back
elseif ($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) {
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) {
if ($counter == $page) {
$paginate.= "<span class='current'>$counter</span>";
} else {
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// End only hide early pages
else {
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) {
if ($counter == $page) {
$paginate.= "<span class='current'>$counter</span>";
} else {
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";
}
}
}
}
// Next
if ($page < $counter - 1) {
$paginate.= "<a href='$targetpage?page=$next'>>></a>";
} else {
$paginate.= "<span class='disabled'>>></span>";
}
$paginate.= "</div>";
}
?>
</table>
<?php
echo $paginate;
?>