我的顶级列表有这条鳕鱼
$pos=0;
$upit = mysql_query("SELECT * FROM wp_entries ORDER BY vote DESC");
while ($sms = mysql_fetch_array($upit)) {
$pos++;
$data = unserialize($sms['data']);
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
}
data[1] 是名称
数据[2] 是姓氏
短信[投票]是票数
这些顶级列表看起来像这样
1 Novak Djokovic 50
2 Rafael Nadal 35
3 Roger Federer 30
4 Andre Agassi 26
5 Pete Sampras 22
6 Andy Murray 19
7 Chris Evert 13
8 Michael Chang 10
9 Andy Roddick 7
10 Boris Becker 5
11 Björn Borg 1
我希望我的顶级列表看起来像这样
// FINALIST // Limit first 4 // green font 1 Novak Djokovic 50 2 Rafael Nadal 35 3 Roger Federer 30 4 Andre Agassi 26 // OTHERS // All other except first 4 and last 2 // black font 5 Pete Sampras 22 6 Andy Murray 19 7 Chris Evert 13 8 Michael Chang 10 9 Andy Roddick 7 // FALL OUT // Limit last 2 // red font 10 Boris Becker 5 11 Björn Borg 1
我希望你理解我,并且有人知道如何解决这个问题。谢谢。
您可以使用以下代码:
$pos=0;
$upit = mysql_query("SELECT * FROM wp_entries ORDER BY vote DESC");
$max = mysql_num_rows($upit);
$max = $max - 2;
while ($sms = mysql_fetch_array($upit)) {
$pos++;
$data = unserialize($sms['data']);
if ($pos < 5){
// first 4 in different color. Green Font
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
} elseif ($pos <= $max) {
//from 5th to 3rd last (left 2 from bottom) in different color. Black Font
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
} else {
// last 2 in different color. Red Font
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
}
}
我猜你想要这样的东西......然后,您可以根据要设置格式的方式更改echo
代码。
$pos=0;
$upit = mysql_query("SELECT * FROM wp_entries ORDER BY vote DESC");
while ($sms = mysql_fetch_array($upit)) {
$pos++;
$data = unserialize($sms['data']);
if ($pos < 5){
// finalist format (1-4)
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
} elseif ($pos > 9) {
// format fallout users (9+)
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
} else {
// format other (5-9)
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
}
}
假设前 4 个颜色不同,从倒数第 5 个到倒数第 3 个(从底部左 2 个)使用不同的颜色,最后 2 个颜色不同。
因此,首先从SQL查询中找到行总数,以便我们可以放置第二个if条件。
$pos=0;
$upit = mysql_query("SELECT * FROM wp_entries ORDER BY vote DESC");
$max = mysql_num_rows($upit);
$max = $max - 2;
while ($sms = mysql_fetch_array($upit)) {
$pos++;
$data = unserialize($sms['data']);
if ($pos < 5){
// first 4 in different color. Green Font
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
} elseif ($pos <= $max) {
//from 5th to 3rd last (left 2 from bottom) in different color. Black Font
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
} else {
// last 2 in different color. Red Font
echo " ".$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms[vote]." ";
}
}
假设你需要HTML输出,这里有一个非常粗略的方法:
<?php
$pos = 0;
if( $upit = mysql_query( "SELECT * FROM wp_entries ORDER BY vote DESC" ) )
{
$num_rows = mysql_num_rows( $upit );
if( $num_rows > 0 )
{
echo '<ul>';
while ($sms = mysql_fetch_array($upit))
{
$pos++;
$style = "";
if ($pos < 5)
{
$style = ' style="color:#00FF00;"';
}
elseif ($pos <= ($num_rows-2))
{
$style = ' style="color:#000000;"';
}
else
{
$style = ' style="color:#FF0000;"';
}
$data = unserialize($sms['data']);
echo ' <li'.$style.'>'.$pos." ".$data[1]['value']." ".$data[2]['value']." ".$sms['vote']."<li>";
}
echo '<ul>';
}
}
?>