not GROUP BY but similar I guess

[bormuff98]

So I have a page which lists a number of products along with the supplier. Each product also falls into one of 3 categories (long-life, short-life, organic).

When displaying the entire product list I want to be able to goup all the long-life products together, followed by short-life then organics, e.g.

Long-Life
=========
Product A               Supplier
Product B               Supplier

Short-life
==========
Product C               Supplier
Product D               Supplier

From what I can tell, GROUP BY is not valid for this kind of thing and the only other function I can see that might work is foreach() but I'm not even sure how to do that!

My code so far is:

$select = mysql_query("
	SELECT products.*, prodtypes.prodtype
	FROM products
	LEFT JOIN prodtypes ON prodtypes.typeID=products.type
	ORDER BY prodID
	",$connection)
	or die("Couldn't execute SELECT query: ".mysql_error());

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

[code output here]

}

Any help/guidance on this would be greatly appreciated.

James

[su1d]

something like that?

$select = mysql_query("
    SELECT products.*, prodtypes.prodtype
    FROM products
    LEFT JOIN prodtypes ON prodtypes.typeID=products.type
    ORDER BY prodtypes.prodtype, prodID
    ",$connection)
    or die("Couldn't execute SELECT query: ".mysql_error());

$cur_prod = 0;
while ($row = mysql_fetch_array($select)) {
    if($cur_prod != $row['prodtype']) {
        $cur_prod = $row['prodtype'];
        echo("Prod\n====");
    }

[code output here]

}

[bormuff98]

Yea, something pretty close to that! Thank you very much 🙂 For anyone who might be interested in this same thing, here is my final code output bit (This works although there may be a better solution).

$cur_prod = 0;

while ($row = mysql_fetch_array($select)) {
	$prodID=$row['prodID'];
	$prodtype=$row['prodtype'];
	$name=$row['name'];
	$suppName=$row['suppName'];
	if ($row['newprod'] == "1") {
		$newimg = "<img src='img/new.gif' alt='New Product'>";
	} else {
		$newimg = "";
	}

if($cur_prod != $row['type']) {
	$cur_prod = $row['type'];
	$productlist .= "
		<tr class='prod-output'>
			<td colspan='3'><b>$prodtype</b></td>
		</tr>
		<tr class='prod-output'>
			<td><a href='details.php?prodID=$prodID'>$name</a></td>
			<td>$suppName</td>
			<td>$newimg</td>
		</tr>
	";
} else {
    	$productlist .= "
		<tr class='prod-output'>
			<td><a href='details.php?prodID=$prodID'>$name</a></td>
			<td>$suppName</td>
			<td>$newimg</td>
		</tr>
	";
}
}