Group by Make...

[nikomou]

Hello, i have this script below to show mobile phones available on a network. is it possible to group the handsets by Make adding the manufacturers name before the products?? e.g.

Nokia Mobile phones
n80, n95, etc

Sony Ericson Mobile Phones
w800i, w850i, etc


Thanks




$conn = mysql_connect($address, $username, $password);
$rs = mysql_select_db($db, $conn);
$sql="SELECT * FROM Offers WHERE NetworkName='$GetNet' GROUP BY ModelName ORDER BY ModelCreated DESC";
$rs = mysql_query($sql, $conn);
$j = 0;
echo("<table><tr>");
while($row = mysql_fetch_array($rs)) {

$ID = $row[xx];
$Make = $row[xxx];

echo("<td width='137'><p align='center'><b>");
echo("<br><a class=\"menusmall\" href=\"xxx.html\"><img alt=\"$Make $Name\" src=\"xxx\" border=\"0\"></a><br><br>");
echo("</td>");

$j++;
if(($j % 4) == 0) echo("</tr>\n<tr>");
}
echo("</tr></table>");
mysql_close();
?>

[allahverdi]

try to group by manufactures name and echo manufactures name.

Or I didn't understand you what you want.

[nikomou]

Hey,

Thanks for the quick reply! what i want to do is to have a manufacturer heading.. so when it changes, it will echo the manufacturers name once, before the products..

similar to this
http://www.mobiles4everyone.com/phones.asp?date=300

[allahverdi]

I said how to do it. Or you need query?