Grouping rows in a loop.

[TimDOES]

I have multiple products for each model in a table and each product is on its own row.

 

eg.

Brand

Type

Model

Brand1

Type1

Model1

Brand1

Type1

Model1

Brand1

Type1

Model1

Brand1

Type2

Model2

Brand1

Type2

Model2

 

Here is the code I have to loop every row (product) of a certain brand. I am trying to create a heading for each model and then list all the available products under it. Right now the loop labels the model for each row. Please tell me there is an easy way to accomplish this. Any help is much appreciated.

 

Code:

 

$query = "select * from ARL2008 where machineMfctr = '$brand'";

 

$result = mysql_query($query);

if (!$result) {

    die("Query to show fields from table failed");

}

$row = mysql_fetch_array($result) or die(mysql_error());

 

while($row = mysql_fetch_array($result)){

echo "<h3>".$row['MachineModel']."</h3>";

echo "<div class='threeCol emptyBlox'>".$row['Brand']."</div><a class='blox' style='padding:0px;' href=''><div class='threeCol'>".$row['DESCR1']."</div></a><a class='blox' style='padding:0px;' href=''><div class='threeCol'>$".$row['Retail']."</div></a>";

echo "<div class='clear'></div>";

}

[fenway]

This doesn't really sound like a DB question... though if that's all in one table, you need to normalize your tables.