<?php
$str_sql="select * from day_data where year=2660 and month=9";
$result=mysql_query($str_sql) or die(mysql_error()); while ($record = mysql_fetch_object($result))
{
if ($record->day >= 15 && $record->day <=17)
{
echo $record->day.":".$record->counts."<br>";
}
else
{
echo "<br>";
}
}?>
$str_sql="select * from day_data where year=2660 and month=9";
$result=mysql_query($str_sql) or die(mysql_error()); while ($record = mysql_fetch_object($result))
{
if ($record->day >= 15 && $record->day <=17)
{
echo $record->day.":".$record->counts."<br>";
}
else
{
echo "<br>";
}
}?>
{
if ($record->day >= 15 && $record->day <=17)
{
echo $record->day.":".$record->counts."<br>";
}
else
{
echo $record->day.":0<br>";
}
}
{
echo "<br>";
}中间的就可以了。
$str_sql="select * from day_data where year=2660 and month=9";
$result=mysql_query($str_sql) or die(mysql_error()); while ($record = mysql_fetch_object($result))
{
$date[$record->day] = $record->counts;
}
for($i = 1;$i <= 31;$i++)
{
if (!empty($date[$i]))
{
echo $i.":".$date[$i]."<br>";
}
else
{
echo $i.":0<br>";
}
}
?>