The client wants a list of products grouped by name, and subgrouped by description, for example:
Name 1
Description 1.1
Description 1.2
Description 1.3
Name 2
Description 2.1
Description 2.2
...
In ColdFusion, the code would be something like:
Code: Select all
<cfoutout query=”products” group=”name”>
<p>#products.name#
<cfoutput group=”description”>
<br>#products.description#
</cfoutout>
</cfoutput>Code: Select all
<?php
while($row = mysql_fetch_array($result))
{
?>
<?php echo $row["productName"]; ?>
...
<?php
}
?>Thanks in anticipation
Philip