
Untitled
By: a guest on
Apr 15th, 2012 | syntax:
None | size: 1.69 KB | hits: 14 | expires: Never
<?php
// Gather Information
$total_actions_01 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-01-01' AND '2010-01-31' "));
$total_actions_02 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-02-01' AND '2010-02-31' "));
$total_actions_03 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-03-01' AND '2010-03-31' "));
$total_actions_04 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-04-01' AND '2010-04-31' "));
$total_actions_05 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-05-01' AND '2010-05-31' "));
$total_actions_06 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-06-01' AND '2010-06-31' "));
$total_actions_07 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-07-01' AND '2010-07-31' "));
$total_actions_08 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-08-01' AND '2010-08-31' "));
$total_actions_09 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-09-01' AND '2010-09-31' "));
$total_actions_10 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-10-01' AND '2010-10-31' "));
$total_actions_11 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-11-01' AND '2010-11-31' "));
$total_actions_12 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-12-01' AND '2010-12-31' "));
?>