Adding up the numbers.

[Odublar]

So I have a menu, and it has this....

category 1 (12)
category 2 (53)
category 3 (36)

of course, this is added from the database, that someone else built....so I need to figure out the variables that make the numbers for each entry to the particular category, but how do I make a solid number of all the categories?

thanks in advance for any ideas. If you need any additional information, please ask.

Thanks.

Steve

[thorpe]

im afraid your going to be a little clearer, i have no idea what you meen.

[Odublar]

ok, give me a second to clarify it, with an example....

[Odublar]

ok, check this out, it's still in the works, but it's an example....

http://www.humorzilla.com/maingreentemplate.php

See the numbers besides the categories? That states how many inputs are in each category as of that moment, well, I want a output for all inputs from all the categories.

BTW, if you are running mozilla/linux, the tables will appear off for now. The site is still in development.

[thorpe]

depending on your db structure, it would just be a matter of running a count query to get the total articles from all catigories. we need to see some code. in particular, the code that gets that menu from the database.

[Odublar]

alright, let me look at it, and get back to you on that one....give me a few minutes.

[Odublar]

//create categories
$qc = "select * from dd_categories order by CategoryName";
$rc = mysql_query($qc) or die(mysql_error());

if(mysql_num_rows($rc) > '0')
{
while($ac = mysql_fetch_array($rc))
{
//get the items number at this category
$qin = "select count(*) from dd_items where ItemCategory = '$ac[CategoryID]' and ItemStatus = 'approved' ";
$rin = mysql_query($qin) or die(mysql_error());
$ain = mysql_fetch_array($rin);

	$categories .= "<a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]\">$ac[CategoryName] ($ain[0])</a><br>\n\t\t\t";

	if($_GET[CategoryID] == $ac[CategoryID])
	{
		$categories .= "<ul style=\"margin-top:0; margin-bottom:0; margin-left:15\">";
		//get the subcategories
		$qsc = "select * from dd_subcategories where CategoryID = '$_GET[CategoryID]' order by SubcategoryName ";
		$rsc = mysql_query($qsc) or die(mysql_error());

		if(mysql_num_rows($rsc) > '0')
		{
			while($asc = mysql_fetch_array($rsc))
			{
				//get the items number at this subcategory
				$qin2 = "select count(*) from dd_items where ItemCategory = '$_GET[CategoryID]' and ItemSubcategory = '$asc[SubcategoryID]' and ItemStatus = 'approved' ";
				$rin2 = mysql_query($qin2) or die(mysql_error());
				$ain2 = mysql_fetch_array($rin2);

				$categories .= "<li><a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]&SubcategoryID=$asc[SubcategoryID]\">$asc[SubcategoryName] ($ain2[0])</a></li>";
			}
		}
		$categories .= "</ul>";
	}

}

}

This is how it's inputted. In the actual page, of course, it's displayed using the simple text

<?=$categories?>

let me know if you can help...and thanks in advance.

[toplay]

You leave out the "WHERE" clause to get a total count. Simply:

select count(*) from dd_items

.

[Odublar]

awesome, thank you so much thorpe and toplay.

[Odublar]

lol, ok guys, I may need a few more notes here... I added something somewhere to allow it to do this....here's the code for you....atleast this is a learning experience....

//create categories
$qc = "select * from dd_categories order by CategoryName";
$rc = mysql_query($qc) or die(mysql_error());

if(mysql_num_rows($rc) > '0')
{
while($ac = mysql_fetch_array($rc))
{
//get the items number at this category
$qin3 = "select count(*) from dd_items ";
$rin3 = mysql_query($qin3) or die(mysql_error());
$ain3 = mysql_fetch_array($rin3);

	$totalnumber .= "Total: ($ain3[0])<br>\n\t\t\t";

	$qin = "select count(*) from dd_items where ItemCategory = '$ac[CategoryID]' and ItemStatus = 'approved' ";
	$rin = mysql_query($qin) or die(mysql_error());
	$ain = mysql_fetch_array($rin);

	$categories .= "<a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]\">$ac[CategoryName] ($ain[0])</a><br>\n\t\t\t";

	if($_GET[CategoryID] == $ac[CategoryID])
	{
		$categories .= "<ul style=\"margin-top:0; margin-bottom:0; margin-left:15\">";
		//get the subcategories
		$qsc = "select * from dd_subcategories where CategoryID = '$_GET[CategoryID]' order by SubcategoryName ";
		$rsc = mysql_query($qsc) or die(mysql_error());

		if(mysql_num_rows($rsc) > '0')
		{
			while($asc = mysql_fetch_array($rsc))
			{
				//get the items number at this subcategory
				$qin2 = "select count(*) from dd_items where ItemCategory = '$_GET[CategoryID]' and ItemSubcategory = '$asc[SubcategoryID]' and ItemStatus = 'approved' ";
				$rin2 = mysql_query($qin2) or die(mysql_error());
				$ain2 = mysql_fetch_array($rin2);

				$categories .= "<li><a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]&SubcategoryID=$asc[SubcategoryID]\">$asc[SubcategoryName] ($ain2[0])</a></li>";
			}
		}
		$categories .= "</ul>";
	}

}

}

so, when I add in <?=$totalnumber?> it adds it up and displays it the as many times as their are categories...

to see it in action, check out

http://www.humorzilla.com/maingreentemplate.php

thanks in advance, again (BP)

Steve

[toplay]

You need to execute it outside the "while" loop. Put it after!

.

[Odublar]

will do. thanks again.

[Odublar]

//create total number
$tc = "select * from dd_categories order by CategoryName";
$sc = mysql_query($tc) or die(mysql_error());

if(mysql_num_rows($sc) > '0')
{
while($uc = mysql_fetch_array($sc))
{
//get the items number at this category
$tin3 = "select count(*) from dd_items ";
$sin3 = mysql_query($tin3) or die(mysql_error());
$uin3 = mysql_fetch_array($sin3);

	$totalnumber .= "Total: ($uin3[0])<br>\n\t\t\t";
}

}

//create categories
$qc = "select * from dd_categories order by CategoryName";
$rc = mysql_query($qc) or die(mysql_error());

if(mysql_num_rows($rc) > '0')
{
while($ac = mysql_fetch_array($rc))
{
//get the items number at this category

	$qin = "select count(*) from dd_items where ItemCategory = '$ac[CategoryID]' and ItemStatus = 'approved' ";
	$rin = mysql_query($qin) or die(mysql_error());
	$ain = mysql_fetch_array($rin);

	$categories .= "<a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]\">$ac[CategoryName] ($ain[0])</a><br>\n\t\t\t";

	if($_GET[CategoryID] == $ac[CategoryID])
	{
		$categories .= "<ul style=\"margin-top:0; margin-bottom:0; margin-left:15\">";
		//get the subcategories
		$qsc = "select * from dd_subcategories where CategoryID = '$_GET[CategoryID]' order by SubcategoryName ";
		$rsc = mysql_query($qsc) or die(mysql_error());

		if(mysql_num_rows($rsc) > '0')
		{
			while($asc = mysql_fetch_array($rsc))
			{
				//get the items number at this subcategory
				$qin2 = "select count(*) from dd_items where ItemCategory = '$_GET[CategoryID]' and ItemSubcategory = '$asc[SubcategoryID]' and ItemStatus = 'approved' ";
				$rin2 = mysql_query($qin2) or die(mysql_error());
				$ain2 = mysql_fetch_array($rin2);

				$categories .= "<li><a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]&SubcategoryID=$asc[SubcategoryID]\">$asc[SubcategoryName] ($ain2[0])</a></li>";
			}
		}
		$categories .= "</ul>";
	}

}

}

So this is what I did, yet it still does the same thing. I'm not a php coder, so I just went with what made sense to me. lol. hope it seems like it made a little sense... BP

please help again. thanks.

[Odublar]

also...

$tc = "select * from dd_categories order by CategoryName";

$tc = "select * from dd_items ";

when I replaced line 1 with line 2, it added even more calls of it, so I'm just messing with it to see what I can get...

[Odublar]

HAHA! figured it out myself! Thanks for the assistance guys. heres the code in case anyone wants this puzzle solved for later....

//create total number

{
//get the items number at this category
$tin3 = "select count(*) from dd_items ";
$sin3 = mysql_query($tin3) or die(mysql_error());
$uin3 = mysql_fetch_array($sin3);

	$totalnumber .= "Total: ($uin3[0])<br>\n\t\t\t";
}

//create categories
$qc = "select * from dd_categories order by CategoryName";
$rc = mysql_query($qc) or die(mysql_error());

if(mysql_num_rows($rc) > '0')
{
while($ac = mysql_fetch_array($rc))
{
//get the items number at this category

	$qin = "select count(*) from dd_items where ItemCategory = '$ac[CategoryID]' and ItemStatus = 'approved' ";
	$rin = mysql_query($qin) or die(mysql_error());
	$ain = mysql_fetch_array($rin);

	$categories .= "<a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]\">$ac[CategoryName] ($ain[0])</a><br>\n\t\t\t";

	if($_GET[CategoryID] == $ac[CategoryID])
	{
		$categories .= "<ul style=\"margin-top:0; margin-bottom:0; margin-left:15\">";
		//get the subcategories
		$qsc = "select * from dd_subcategories where CategoryID = '$_GET[CategoryID]' order by SubcategoryName ";
		$rsc = mysql_query($qsc) or die(mysql_error());

		if(mysql_num_rows($rsc) > '0')
		{
			while($asc = mysql_fetch_array($rsc))
			{
				//get the items number at this subcategory
				$qin2 = "select count(*) from dd_items where ItemCategory = '$_GET[CategoryID]' and ItemSubcategory = '$asc[SubcategoryID]' and ItemStatus = 'approved' ";
				$rin2 = mysql_query($qin2) or die(mysql_error());
				$ain2 = mysql_fetch_array($rin2);

				$categories .= "<li><a class=CatLinks href=\"ShowCategory.php?CategoryID=$ac[CategoryID]&SubcategoryID=$asc[SubcategoryID]\">$asc[SubcategoryName] ($ain2[0])</a></li>";
			}
		}
		$categories .= "</ul>";
	}

}

}

slowly, I take it in.... (BD)

[Odublar]

Thanks to your guys help, I was able to add the amount of members and ratings so far by myself. I really want to extend my gratitude, and let you know I appreciate your knowledge.

To check it out, go to http://www.humorzilla.com/maingreentemplate.php