MySQL benzer değerini seçmek ve sonuç sipariş

1 Cevap php

nasıl bu sonucu sipariş edebilirim?

$range = 5;  // you'll be selecting around this range. 
$min = $rank - $range;
$max = $rank + $range;
$limit = 10; // max number of results you want. 

$result = mysql_query("select * from table where rank between $min and $max limit $limit");

while($row = mysql_fetch_array($result))
{
   echo $row['name']."&nbsp;-&nbsp;".$row['rank']."<br>";
}

1 Cevap

: Fıkra - "tarafindan" kullanın

mysql_query("select * from table where rank between $min and $max order by rank limit $limit");

This will order your result from little to big values. Use "order by rank desc" to order in descendent direction. (big -> little)

etiketler