help with arrays

rishirajsingh

My table structure is like

I want to select all products from table and arrange them in categories. I am using two dimensional array and then foreach loop to do it but not able to suceed. Please help with logic and code.

I want to print my products like this.

Category1 :
Product1
Product2
Product3
Product4
Product5
Product6

Category2:
Product7
Product8
Product9

Category3:
Product10
Product11
Product12
Product13

NogDog

I usually do something like this:

<?php
$sql = "SELECT `category`, `product` FROM `products` ORDER BY `category`, `product`";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result))
{
   $category = '';
   $started = FALSE;
   while($row = mysql_fetch_assoc($result))
   {
      if($row['category'] != $category)
      {
         $category = $row['category'];
         if($started)
         {
            echo "</ul>\n";
         }
         else
         {
            $started = TRUE;
         }
         echo "<h2>" . $row['cateogry'] . "<h2>\n<ul>\n";
      }
      echo "<li>" . $row['product'] . "</li>\n";
   }
   echo "</ul>\n";
}
?>

cgraz

$query = mysql_query("select Category
  , group_concat(Product SEPARATOR '<br />') as Products
 from your_table
group
   by Category
order
   by Category");

while($row = mysql_fetch_object($query))
{
	print $row->Category . ':<br />';
	print $row->Products . '<br />';
}

NogDog

cgraz wrote:

$query = mysql_query("select Category
  , group_concat(Product SEPARATOR '<br />') as Products
 from your_table
group
   by Category
order
   by Category");

while($row = mysql_fetch_object($query))
{
	print $row->Category . ':<br />';
	print $row->Products . '<br />';
}

I like this idea, except I might tweak it to produce more semantically meaningful HTML:

$query = mysql_query("select Category
  , group_concat(Product SEPARATOR '</li><li>') as Products
 from your_table
group
   by Category
order
   by Category");

while($row = mysql_fetch_object($query))
{
	print '<h3>' . $row->Category . "</h3>\n<ul>\n";
	print '<li>' . $row->Products . "</li>\n</ul>\n";
}