我有mysql数据库,里面有超过2年的数据。如何进行查询,以获得如下结果:
January
Week 1
...
data rows here
....
Week 2
...
...
Week 3
...
...
Week 4
...
...
February (same as above)以下是字段结构:
- date (in yyyy-mm-dd format)
- job (integer autoincrement)
- person (varchar)发布于 2011-12-08 20:01:58
尝试一下,它将生成与您所需的输出非常相似的输出
SELECT MONTH(date) AS MONTH, WEEK(date) AS WEEK, DATE_FORMAT(date, %Y-%m-%d) AS DATE, job AS JOB, person AS PERSON GROUP BY WEEK(date);发布于 2011-12-08 19:54:58
GROUP BY year(record_date), MONTH(record_date)查看MySQL中的date and time functions。
发布于 2011-12-08 20:00:55
它必须是一个查询,或者你也可以使用ajax?使用ajax,你可以在javascript中执行一个循环:
date = [initial date]
while date <= [final date] {
divUpdate = 'divrecs'; // will be used in updateDiv function
url = 'getrecs.php?date1='+date+'&date2='+(date+6);
conecta(url,updateDiv);
date = date+7;
}在getrecs中,你的查询应该是:
$stmt = $dbh->prepare("select * from yourtable where date >= '".$_GET['date1']."' and date <= '".$_GET['date2']."'");
if ($stmt->execute()) {
while ($row = $stmt->fetch(PDO::FETCH_BOTH)) {
echo "Do anything with your data here: $row[1] etc<BR>";
}
}希望这能有所帮助!
https://stackoverflow.com/questions/8430600
复制相似问题