|
Last Week |
Last Month |
Last 3 Month |
= (curdate() - INTERVAL 7 DAY), 1, 0) ) as total_lastweek
, sum( IF(start_date >= (curdate() - INTERVAL 1 month), 1, 0) ) as total_lastmonth
, sum( IF(start_date >= (curdate() - INTERVAL 3 month), 1, 0) ) as total_last3month
FROM screenshot
WHERE priority = 1";
if(!$screenshot_result = mysql_query($sql))
showerror();
if($screenshot_row = mysql_fetch_array($screenshot_result))
{
?>
| Priority 1 |
"> |
"> |
"> |
= (curdate() - INTERVAL 7 DAY), 1, 0) ) as total_lastweek
, sum( IF(start_date >= (curdate() - INTERVAL 1 month), 1, 0) ) as total_lastmonth
, sum( IF(start_date >= (curdate() - INTERVAL 3 month), 1, 0) ) as total_last3month
FROM screenshot
WHERE 1";
if(!$screenshot_result = mysql_query($sql))
showerror();
if($screenshot_row = mysql_fetch_array($screenshot_result))
{
?>
| All Screenshots |
"> |
"> |
"> |