Advertisement
Guest User

Untitled

a guest
Sep 18th, 2012
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.79 KB | None | 0 0
  1. for ($i = 1; $i < 8; $i++) {
  2.         $today = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-$i,date("Y")));
  3.  
  4.         /** Classique **/
  5.         $c[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'c' AND `date` LIKE '".$today."%'");
  6.  
  7.         /** Classique avec Annonces **/
  8.         $ca[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'ca' AND `date` LIKE '".$today."%'");
  9.  
  10.         /** Coinche **/
  11.         $co[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'co' AND `date` LIKE '".$today."%'");
  12.  
  13.         /** Coinche avec Annonces **/
  14.         $coa[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'coa' AND `date` LIKE '".$today."%'");
  15.  
  16.         /** Moderne **/
  17.         $m[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'm' AND `date` LIKE '".$today."%'");
  18.  
  19.         /** Moderne avec Annonces **/
  20.         $ma[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'ma' AND `date` LIKE '".$today."%'");
  21.  
  22.         $tB[$i] = "0";
  23.         $tB[$i] = $c[$i] + $ca[$i] + $m[$i] + $ma[$i];
  24.         echo ("Belote ".$today. " ".$tB[$i]. " ---- ");
  25.  
  26.         $tC[$i] = "0";
  27.         $tC[$i] = $co[$i] + $coa[$i];
  28.         echo ("Coinche ".$today. " ".$tC[$i]. " ---- ");
  29.  
  30.         /** Tarot 3 **/
  31.         $t3[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 't3' AND `date` LIKE '".$today."%'");
  32.  
  33.         /** Tarot 4 **/
  34.         $t4[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 't4' AND `date` LIKE '".$today."%'");
  35.  
  36.         /** Tarot 5 **/
  37.         $t5[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 't5' AND `date` LIKE '".$today."%'");
  38.  
  39.         $t[$i] = $t3[$i] + $t4[$i] + $t5[$i];
  40.         echo ("Tarot ".$today. " ".$t[$i]." ---- ");
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement