[RESOLVED] Loops and counts

[bastienvans]

Hey everyone,

This is my code:

$dates = array("2010-05-27","2010-05-28","2010-05-29","2010-05-30","2010-05-31","2010-06-01");
$seasons = array("April/May","June","July/Early August");


foreach($seasons as $var)
	{
		foreach($dates as $items)
			{
				$query = "SELECT * FROM rates WHERE (`starting` <= '$items' AND `ending` >= '$items' and propertyID='$propertyID' and season='$var')";
				$result = mysql_query($query) or die(mysql_error());
					while ($row = mysql_fetch_array($result)) 
						{ 
							echo "$items - $row[season] - Rates: $row[day]<br />";
						}
			}
	}

This outputs:

2010-05-27 - April/May - Rates: 69
2010-05-28 - April/May - Rates: 69
2010-05-29 - June - Rates: 99
2010-05-30 - June - Rates: 99
2010-05-31 - June - Rates: 99
2010-06-01 - June - Rates: 99

I need to know how many results are returned by 'season'. For instance, in this example, I would like to get:

2010-05-27 - April/May - Rates: 69 - Count: 1
2010-05-28 - April/May - Rates: 69 - Count: 2
2010-05-29 - June - Rates: 99 - Count: 1
2010-05-30 - June - Rates: 99 - Count: 2
2010-05-31 - June - Rates: 99 - Count: 3
2010-06-01 - June - Rates: 99 - Count: 4

Ultimately I want to end up with:

April/May - Count: 2
June - Count: 4

Thank you!

[bastienvans]

Got it figured out, thanks anyways.

$dates = array("2010-05-27","2010-05-28","2010-05-29","2010-05-30","2010-05-31","2010-06-01");
$seasons = array("April/May","June","July/Early August");

foreach($seasons as $var)
{
$count[$var] = 0;
foreach($dates as $items)
{
	$query = "SELECT * FROM rates WHERE (`starting` <= '$items' AND `ending` >= '$items' and propertyID='$propertyID' and season='$var')";
	$result = mysql_query($query) or die(mysql_error());
		while ($row = mysql_fetch_array($result)) 
			{ 
				echo "$items - $row[season] - Rates: $row[day] <br />";
				$count[$var]++;
			}	
}
if($count[$var] != 0) { echo $count[$var]."<br />"; }
}