Count Items in Categories

sktbrd341

I have a website that sells computer software and its setup with 10 Categories and in each categorie there is about 10 more subcategories in the categories. i want to be able to count the items in the subcategorie and display the number next to the subcat name and then i want that number to be displayed next to the categories name.

example i have a categorie of Games and in the categorie there is Action and Adventure as subcats. so lets say i have 5 items in Action i want that 5 to show up next to the subcats name. also i have 4 in Adventure and that number should show up next to the name too. But then next to Games i want it to show the number 9. because that is the number of items in the categorie.

I know that i have to count the items somehow and add them up and stuff but i dont know how i would do that in PHP.

Can anybody help me at all i would appreciate it.

Thank you in Advance

devinemke

i'm just guessing here at your data structure:

SELECT COUNT(*), subcat FROM software_titles GROUP BY subcat

sktbrd341

<?php
//connect to database
$conn = mysql_connect("localhost", "x", "x") or die(mysql_error());
mysql_select_db("hexsoft_storefront",$conn) or die(mysql_error());

$display_block = "<h1>My Categories</h1>
<P>Select a category to see its items.</p>";

//show categories first
$get_cats = "select id, cat_title from store_categories order by cat_title";
$get_cats_res = mysql_query($get_cats) or die(mysql_error());

if (mysql_num_rows($get_cats_res) < 1) {
$display_block = "<P><em>Sorry, no categories to browse.</em></p>";
} else {

while ($cats = mysql_fetch_array($get_cats_res)) {
    $cat_id  = $cats[id];
    $cat_title = strtoupper(stripslashes($cats[cat_title]));


    $display_block .= "<p><strong><a href=\"$_SERVER[PHP_SELF]?cat_id=$cat_id\">$cat_title</a>$items_amount</strong></p>";

if ($_GET[cat_id] == $cat_id) {
   //get subcats
   $get_subcats = "select id, subcat_title from store_subcat where cat_id = $cat_id order by subcat_title";

"select count(subcat_id) from store_items where subcat_id =$subcats_id";
$get_subcats_res = mysql_query($get_subcats) or die(mysql_error());

   if (mysql_num_rows($get_subcats_res) < 1) {
	$display_block = "<P><em>Sorry, no items in this category.</em></p>";
   } else {

	$display_block = "$cat_title";

	while ($subcats = mysql_fetch_array($get_subcats_res)) {
	   $subcats_id = $subcats[id];
	   $subcats_title = stripslashes($subcats[subcat_title]);
               $items_amount = ($subcats[count]);


	   $display_block .= "<p><li><strong><a href=\"seeitemlist.php?subcats_id=$subcats_id\">$subcats_title</a>$items_amount</strong></li></p>"; 
	}

   break;	


 }
}

}
}
?>
<HTML>
<HEAD>
<TITLE>My Categories</TITLE>
</HEAD>
<BODY>
<? print $display_block; ?>
</BODY>
</HTML>

This is wut i got can anybody help me figure it out because i have no clue wut im doing

sktbrd341

nobody can help me at all?