$link 为数据库连接;
$m_row=sql_query("select * from table ",$link);
while($m_rt=sql_fetch_array($m_row)){
if( ( $m_k - 2*floor($m_k/2)) == 1 ){
?>
<tr height=25px style="font-color:#ffffff;">
<td width="15%" ><?php echo $m_rt["part_id"]; ?></td>
<td width="6%"><?php echo $m_rt["procedure_no"]; ?></td>
<td width="35%"><?php echo $m_rt["procedure_explain"]; ?></td>
<td width="10%"><?php echo $m_rt["lot_no"]; ?></td>
<td width="8%"><?php echo $m_rt["p_proc_time"]; ?></td>
<td width="8%"><?php echo $m_rt["p_finish_time"]; ?></td>
<td width="9%"><?php echo $m_rt["quantity"]; ?></td>
<td width="9%"><?php echo $m_rt["finish_qty"]; ?></td>
</tr>
<?php
}
if( ( $m_k - 2*floor($m_k/2)) == 0 ){
?>
<tr height=25px style="font-color:#000000;"> >
<td width="15%" ><?php echo $m_rt["part_id"]; ?></td>
<td width="6%"><?php echo $m_rt["procedure_no"]; ?></td>
<td width="35%"><?php echo $m_rt["procedure_explain"]; ?></td>
<td width="10%"><?php echo $m_rt["lot_no"]; ?></td>
<td width="8%"><?php echo $m_rt["p_proc_time"]; ?></td>
<td width="8%"><?php echo $m_rt["p_finish_time"]; ?></td>
<td width="9%"><?php echo $m_rt["quantity"]; ?></td>
<td width="9%"><?php echo $m_rt["finish_qty"]; ?></td>
</tr>
<?php
}
$m_k++;
}
?>
$m_row=sql_query("select * from table ",$link);
while($m_rt=sql_fetch_array($m_row)){
if( ( $m_k - 2*floor($m_k/2)) == 1 ){
?>
<tr height=25px style="font-color:#ffffff;">
<td width="15%" ><?php echo $m_rt["part_id"]; ?></td>
<td width="6%"><?php echo $m_rt["procedure_no"]; ?></td>
<td width="35%"><?php echo $m_rt["procedure_explain"]; ?></td>
<td width="10%"><?php echo $m_rt["lot_no"]; ?></td>
<td width="8%"><?php echo $m_rt["p_proc_time"]; ?></td>
<td width="8%"><?php echo $m_rt["p_finish_time"]; ?></td>
<td width="9%"><?php echo $m_rt["quantity"]; ?></td>
<td width="9%"><?php echo $m_rt["finish_qty"]; ?></td>
</tr>
<?php
}
if( ( $m_k - 2*floor($m_k/2)) == 0 ){
?>
<tr height=25px style="font-color:#000000;"> >
<td width="15%" ><?php echo $m_rt["part_id"]; ?></td>
<td width="6%"><?php echo $m_rt["procedure_no"]; ?></td>
<td width="35%"><?php echo $m_rt["procedure_explain"]; ?></td>
<td width="10%"><?php echo $m_rt["lot_no"]; ?></td>
<td width="8%"><?php echo $m_rt["p_proc_time"]; ?></td>
<td width="8%"><?php echo $m_rt["p_finish_time"]; ?></td>
<td width="9%"><?php echo $m_rt["quantity"]; ?></td>
<td width="9%"><?php echo $m_rt["finish_qty"]; ?></td>
</tr>
<?php
}
$m_k++;
}
?>
$k = 0;
while(row = mysql_fetch_row($rs)) {
echo "<font color='{$font_color[$k]}'>";
.... //输出相应内容
echo "</font>";
$k %= $k+1;
}
$k %= $k+1;
应为
$k = ($k+1)%2;
wuxyun(巫行云)说得对!
$result = mysql_query($sql);
while($dbRow = mysql_fetch_object($result))
{
if($color=="000000")$color = "ffffff";
else $color = "000000";
echo "<font color=$color>".$dbRow->xxxxx;//你的字段
}
$i="000000";
while($data=mysql_fetch_object($rs))
{
$i="000000"?"ffffff":"000000";
echo "<font color=".$i.">".$data->id."</font>";
}
{
echo "<font color=\"".$font_color[$k]."\">";
.... //输出相应内容
echo "</font>";
if($k)
$k =0;
else
$k=1;
}