問題描述
我想這很簡單，但無法弄清楚.我正在嘗試制作幾頁 - 其中包含從我的 mysql db 表中選擇的今天、本周和本月的結果.日期是在使用 date('Y-m-d H:i:s'); 創建記錄時輸入的.這是我到目前為止所擁有的:
I imagine this is pretty simple, but can't figure it out. I'm trying to make a few pages - one which will contain results selected from my mysql db's table for today, this week, and this month. The dates are entered when the record is created with date('Y-m-d H:i:s');. Here's what I have so far:
day where date>(date-(60*60*24))
day where date>(date-(60*60*24))
"SELECT * FROM jokes WHERE date>(date-(60*60*24)) ORDER BY score DESC"
日期所在的星期>(日期-(60*60*24*7))
week where date>(date-(60*60*24*7))
"SELECT * FROM jokes WHERE date>(date-(60*60*24*7)) ORDER BY score DESC"
月(30天)其中日期>(日期-(60*60*24*30))
month (30 days) where date>(date-(60*60*24*30))
"SELECT * FROM jokes WHERE date>(date-(60*60*24*30)) ORDER BY score DESC"
任何想法將不勝感激.謝謝！
Any ideas would be much appreciated. Thanks!
推薦答案
假設您的日期列是實際的 MySQL 日期列:
Assuming your date column is an actual MySQL date column:
SELECT * FROM jokes WHERE date > DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY score DESC;
SELECT * FROM jokes WHERE date > DATE_SUB(NOW(), INTERVAL 1 WEEK) ORDER BY score DESC;
SELECT * FROM jokes WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) ORDER BY score DESC;
這篇關于選擇今天、本周、本月的記錄 php mysql的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！