Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for ($i = 1; $i < 8; $i++) {
- $today = date("Y-m-d", mktime(0,0,0,date("m"),date("d")-$i,date("Y")));
- /** Classique **/
- $c[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'c' AND `date` LIKE '".$today."%'");
- /** Classique avec Annonces **/
- $ca[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'ca' AND `date` LIKE '".$today."%'");
- /** Coinche **/
- $co[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'co' AND `date` LIKE '".$today."%'");
- /** Coinche avec Annonces **/
- $coa[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'coa' AND `date` LIKE '".$today."%'");
- /** Moderne **/
- $m[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'm' AND `date` LIKE '".$today."%'");
- /** Moderne avec Annonces **/
- $ma[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 'ma' AND `date` LIKE '".$today."%'");
- $tB[$i] = "0";
- $tB[$i] = $c[$i] + $ca[$i] + $m[$i] + $ma[$i];
- echo ("Belote ".$today. " ".$tB[$i]. " ---- ");
- $tC[$i] = "0";
- $tC[$i] = $co[$i] + $coa[$i];
- echo ("Coinche ".$today. " ".$tC[$i]. " ---- ");
- /** Tarot 3 **/
- $t3[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 't3' AND `date` LIKE '".$today."%'");
- /** Tarot 4 **/
- $t4[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 't4' AND `date` LIKE '".$today."%'");
- /** Tarot 5 **/
- $t5[$i] = mysql_query("SELECT COUNT(*) FROM `parties` WHERE `type` LIKE 't5' AND `date` LIKE '".$today."%'");
- $t[$i] = $t3[$i] + $t4[$i] + $t5[$i];
- echo ("Tarot ".$today. " ".$t[$i]." ---- ");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement