Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 15th, 2012  |  syntax: None  |  size: 1.69 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <?php
  2.  
  3. // Gather Information
  4. $total_actions_01 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-01-01' AND '2010-01-31' "));
  5. $total_actions_02 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-02-01' AND '2010-02-31' "));
  6. $total_actions_03 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-03-01' AND '2010-03-31' "));
  7. $total_actions_04 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-04-01' AND '2010-04-31' "));
  8. $total_actions_05 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-05-01' AND '2010-05-31' "));
  9. $total_actions_06 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-06-01' AND '2010-06-31' "));
  10. $total_actions_07 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-07-01' AND '2010-07-31' "));
  11. $total_actions_08 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-08-01' AND '2010-08-31' "));
  12. $total_actions_09 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-09-01' AND '2010-09-31' "));
  13. $total_actions_10 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-10-01' AND '2010-10-31' "));
  14. $total_actions_11 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-11-01' AND '2010-11-31' "));
  15. $total_actions_12 = $database->count_rows($database->db_query("SELECT id FROM actions WHERE date BETWEEN '2010-12-01' AND '2010-12-31' "));
  16.  
  17. ?>