lists

hmaffin

I have a table which has a category, then an item.

I want to create a webpage that lists them as follows :

category 1

item 1
item 2
item 3

category 2

item 1
item 2

category 3

item 1
item 2
item 3

but at the moment, my code is producing :

category 1 item 1
category 1 item 2
category 1 item 3
category 2 item 1
category 2 item 2
category 3 item 1

etc etc

i am using :

printf("<tr><td width=\"200\" valign=top><a href=%s>%s</a></td><td width=\"50\" valign=top> </td><td width=\"450\" valign=top>%s </td></tr>\n", $myrow["link"],$myrow["proper"], $myrow["item"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {

sorry if thats confusing. Link and proper are just displaying the category with a hyperlink.

Any help appreciated!
Helen

kilbey1

Here's how I handled it, maybe this will help you. Note the changes - first, you have to do a query through all of your products in the first WHILE statement. While you are looping through your categories (the first WHILE statement), then you need to do a 2nd query statement to match up the products to the categories, and loop through that. I'm assuming you have a relational field (ie. parent_id) to use for comparison...


$query = "YOUR QUERY HERE";
$db_query = mysql_query ($query);

while ($myrow = mysql_fetch_array ($db_query)) {
	echo "<a href=\"products_category.php?id=$myrow[field_id]\">$myrow[field_name]</a><br />\n";

    $sql="YOUR 2nd QUERY HERE";
    $result2=mysql_query ($sql);

    while($myrow2=mysql_fetch_array ($result2)){
            echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"products_category.php?nid=$myrow2[field_id]\">$myrow2[field_name]</a><br />\n";

    }



}