当前PHP查询:
$sql = mysql_query("SELECT stories.*, SUM(votes.vote_value) as 'total_votes' FROM stories JOINvotes ON stories.id = votes.item_name GROUP BY stories.id ORDER BY total_votes DESC LIMIT 10") or die (mysql_error("There was an error in connection"
我一直在手动更新时间戳,以反映当前和上周的情况。我希望它只从当前周的周一到周一和上周的周一到周一的数据中提取数据。$result = mysql_query("SELECT * FROM form_2 WHERE timestamp BETWEEN '2011-11-7' AND '2011-11-14' AND checkcolle