觀看總次數: $row1[1]
\n| 星期
| 日 | 一 | 二 | 三
| 四 | 五 | 六 | 總
end;
$today = substr($row1[0],0,10);
$row1[2] = substr($row1[2],0,10);
$last = $row1[1]-$row2[0];
$w1 = add_day($today, -dow($today));
$w2 = add_day($row1[2], -dow($row1[2]));
$loop = 0;
while ( $w1 >= $w2 ) {
print " | | $w1";
for($i=0, $sum=0; $i<=6; $i++) {
$d1 = add_day( $w1, $i);
$d2 = add_day( $w1, 1+$i);
if ($d1 > $today or $d1<$row1[2]) {
print " | ";
// } elseif ($d1 == $today) {
// print " | $last";
// $sum += $last;
} elseif ($d1 >= $row1[2] ) {
$qry = "select daycount from counter2 where counter=$row1[3] and date=\"$d1\"";
$res = mysql_db_query ("free", $qry, $sql) or die (mysql_error().' '.$qry);
$row = mysql_fetch_row($res);
print " | $row[0] ";
$sum += $row[0];
}
}
print " | $sum | \n";
$w3 = add_day( $w1, -7);
// print "| $w1 | $w2 | $w3 | \n";
$w1 = $w3;
// if($loop++ > 50 ) die("dead loop! w1=$w1, w2=$w2, w3=$w3");
}
print <<
Click-Through 次數
end;
$qry = "select goto,gocount from counter3 where counter=\"$row1[sid]\" order by goto";
$res = mysql_db_query ("free", $qry, $sql) or die (mysql_error().' '.$qry);
while ($row = mysql_fetch_row($res)) print "| $row[0] | $row[1] | 觀看\n";
print <<
網上投票
end;
$qry = "select * from counter4 where counter=\"$row1[sid]\" order by question desc";
$res = mysql_db_query ("free", $qry, $sql) or die (mysql_error().' '.$qry);
while ($row = mysql_fetch_array($res,MYSQL_BOTH)) {
unset($ttl);
print "\n";
print "| $row[question]: $row[head]\n";
$qq = explode(',', $row[opts]);
foreach($qq as $n=>$q) {
$i = $n+1;
$one=$row["vote$i"];
print " | | $q | $one |
\n";
$ttl += $one;
}
print " | | 總數 | $ttl | \n\n |
\n";
}
?>
|
| |