echo "<table>";
$result = Mysql_query("select * from table");
$i=1;
while($rows=mysql_fetch_array($result)){
$tr_color= $i%2==0 ? "#CCCCCC" : "";
echo "<tr bgcolor=".$tr_color."><td>".$rows[fields]."</td></tr>";
$i++;
}
echo "</table>";
$result = Mysql_query("select * from table");
$i=1;
while($rows=mysql_fetch_array($result)){
$tr_color= $i%2==0 ? "#CCCCCC" : "";
echo "<tr bgcolor=".$tr_color."><td>".$rows[fields]."</td></tr>";
$i++;
}
echo "</table>";
echo "<table>";
$i=1;//可设1,2
while($rows=mysql_fetch_array($result)){
if (ceil($i/2)==$i/2) {
echo "<tr bgcolor='#cccccc'><td>".$rows[fields]."</td></tr>";
} else {
echo "<tr bgcolor=''><td>".$rows[fields]."</td></tr>";
}
$i++;
}
echo "</table>";
...
...
while($rows=mysql_fetch_array($result)){
$BGColor=$BGColor=="#FFFFFF"?"#CCCCCC":"#FFFFFF";
echo "<tr bgcolor='$BGColor'>";
...}
...
...
?>
比如:.td0{...} .td1{...}
echo '<td class="td'.(i%2).'" ....>';
function changeColor(){
static $bg_color;
if($bg_color == "#EDEDED"){
$bg_color = "#EFEFEF";
}else{
$bg_color = "EDEDED";
}
return $bg_color;
}
从数据库中取数据并表格显示:
$sql = "select * from Your_db_table_name";
$query = mysql_query($sql,$db);
while($arr_data = mysql_fetch_array($query)){
$trBgColor = changeColor();
echo "<td bgcolor=$tr_bg_color>";
..................
..................
}
mysql_close($db);
这样就可以了.
按上面高手提示多练习一下,
OK!www.yesqq.com
//+==============================================
// lista.php by eagle
// 2003-01-18
//===============================================/function TdBackColor() { //***************表格单元格背景颜色设定
static $ColorStr;
if ($ColorStr=="#ECF6F5")
{
$ColorStr="#F6F6F6";
}
else
{
$ColorStr="#ECF6F5";
}
return($ColorStr);
}
print"<table border=1 width=100% align=center bordercolorlight=#cccccc bordercolordark=#FFFFFF cellspacing=0 >";
for ($i=1;$i<15;$i++)
{
$ColorStr=TdBackColor();
print"<tr bgcolor=$ColorStr >";
print" <td height=22 align=center>";
print "$i";
print"</td>";
print" <td >";
print" <a href=#>欢迎光临,欢乐一起玩</a>";
print" </td>";
print" <td width=15% align=center >";
print "凉开水";
print"</td>";
print" <td >01-01 12:55:11 <font color=#0000ff>eagle_gui</font></td>";
print" <td width=5% align=center>22</td>";
print" <td width=5% align=center><font color=#ff0000>5</font></td>";
print" <td width=3% align=center>";
print"<input type=checkbox name=addfavor[]>";
print"</td>";
print"</tr>";
}
print "</table>";
?>