[PHP] Issues displaying data from database & organizing by category

[Jim]

I'm new to PHP so bare with me please.  I'm collect data fine from mySQL
into an accociative array. I can display it fine.  Here's the issue:

** Looks like this:
GALLERY 1
  Item Name     Item Desc
GALLERY 2
  Item Name     Item Desc
GALLERY 2
  Item Name     Item Desc
GALLERY 3
  Item Name     Item Desc

** Should look like this
GALLERY 1
  Item Name     Item Desc
GALLERY 2
  Item Name     Item Desc
  Item Name     Item Desc
GALLERY 3
  Item Name     Item Desc

I have 2 tables: tblGalleries and tblItems. tblItems has a column
(itmGalley_ID) that corresponds to the gallery it belongs to in
tblGalleries (galID).  I've got my SQL set right (I've tested with mysql
command line).  But I can't get it to display the Gallery (galName),
every item within that gallery, and the next Gallery name going down
with its items and so on.

I've tweaked the while statement, tried foreach loops, reorganizng that
arrys but to no avail.

Bit of my code:

        <?php
        while ($row = mysql_fetch_assoc($result)) {
        ?> 
          <TR>
            <TD>
            <H1><?php echo"{$row['galName']}" ?></H1>
            </TD>
            <TD></TD>
            <TD></TD>
          </TR>
          <TR>
            <TD width="100"><U>Item Name</U></TD>
            <TD width="200"><U>Item Desc</U></TD>
          </TR>
          <TR>
            <TD width="100"><?php echo"{$row['itmItem_Name']}"?></TD>
            <TD width="200"><?php echo"{$row['itmItem_Desc']}"?></TD>
            <TD></TD>
          </TR>
        <?php 
        }
        ?>

Simple issue I'm sure but frustrating..Thanks for the help..


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php