5Lk0h8t0

1Getting number of articles in specific date range
2CREATE TABLE IF NOT EXISTS `articles` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `caption` varchar(255) NOT NULL,
5  `author_id` int(11) NOT NULL,
6  `date_added` datetime NOT NULL,
7  `body` text NOT NULL,
8  `description` varchar(500) NOT NULL,
9  `location` varchar(255) NOT NULL,
10  PRIMARY KEY (`id`),
11  KEY `author_id` (`author_id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
13	
14$sql  = 'SELECT date_added FROM articles ';
15    $sql .= 'WHERE date_added > ' . '"' . $mysql_datetime_start . '" AND ';
16    $sql .= 'date_added < ' . '"' . $mysql_datetime_end . '" ';
17    $sql .= 'GROUP BY date_added ';
18	
19SELECT DATE(date_added), COUNT(*) FROM articles
20WHERE date_added BETWEEN $mysql_datetime_start AND  $mysql_datetime_end 
21GROUP BY DATE(date_added);
22	
23$sql = 
24"SELECT DATE( date_added ), count(*) FROM articles 
25  WHERE date_added > '" . $mysql_datetime_start . "'
26  AND date_added < '" . $mysql_datetime_end . "' 
27  GROUP BY DATE( date_added )"