Ahhh! Query Results

dpoincelot

Hi,

I just can't seem to figure this out, my brain is about to explode.

Here is an explanation of the application:

I have 2 sql tables (categories and subcategories), the subcategories table has a field called "category_included_in" which is a relational mirror of the "id" field in the categories table. Querying this information doesn't appear to be a problem, see below:

$rowset = $dbclass->database_sql("SELECT categories.category, subcategories.subcategory
FROM categories, subcategories
WHERE categories.id = subcategories.category_included_in
ORDER BY category");

while ($rows = mssql_fetch_array($rowset)) {
$cat_list .= "
<p><strong>$rows[category]</strong></p>
<li> $rows[subcategory]";
}

The challenge is that I would like to display the subcategory results like this:

CAT1
subcat (under cat 1)
subcat (under cat 1)

CAT2
subcat (under cat 2)

Instead my results repeat the category and don't group the subcategories:

CAT1
subcat (under cat 1)

etc.

Please HELP!
Dan

essexboy

the guy posted just after u, http://www.phpbuilder.com/board/showthread.php?s=&threadid=10220574

he grouped movies by alpha, i.e. a,b,c,d,e,f,g,h,i etc

tomhath

You need to learn how to use an "if" statement:


$lastCat = "";
while ($rows = mssql_fetch_array($rowset)) { 

  if ($rows[category] != $lastCat) {
    $cat_list .= " <p><strong>$rows[category]</strong></p> ";
    $lastCat = $rows[category];
  }

$cat_list .= "<li> $rows[subcategory]"; 
}

dpoincelot

Sorry for being so slow with that one. I actually understand "if statements" I just had trouble envisioning the process on using it!
Thanks!