Trying to group by year

[RynMan]

Hi guys

 

I've got a set of records pulled via my query.  The three fields are the year a production occurred, the name of the production, and the role the person played in it.  I basically want to display it like this

 

2009

Romeo and Juliet - Romeo

Walking Tall - John

 

2008

Another production - role

Some other production - role

 

Here's my code...

 

$Year = 0;

while($DataArray = mysql_fetch_array($dataquery)) {

if ($Year != $DataArray["Year"]) {

echo $DataArray["Year"]."<br />".
$DataArray["Production"]." ".$DataArray["Role"]."<br />";
$Year = $DataArray["Year"];

} else {
$DataArray["Production"]." - ".$DataArray["Role"]."<br />";
$Year = $DataArray["Year"];

}

}

 

So I'm basically trying to have it look at my year, and if it is the same as the previous record's year, create just the line without the year.  It's not actually peforming my 'else' part of my if statement.  What am I missing?

 

[PFMaBiSmAd]

You don't have an echo statement as part of the else{} code so nothing will be output to the browser.

 

You can also simplify the code (eliminates duplicate code) that is inside of the while(){} loop -

if ($Year != $DataArray["Year"]) {
	echo $DataArray["Year"]."<br />";
	$Year = $DataArray["Year"];
}
echo $DataArray["Production"]." - ".$DataArray["Role"]."<br />";

 

 

[RynMan]

Thanks PFM!  A little too late here, can't believe I missed that one.