[darkcarnival]

hi,

i plan to make a stat section on a program of mine that would display the amount of items a category had and then total it up. my problem is that I dont know how to do it. i mean i know to get the numer of results but i dont know how to do it "x" amount of times. not sure if ne1 gets what im saying but it will output like this:

cat1-300
cat2-300
cat3-500
ect
total-900

if anyone know how to do this please help me. thx very much in advance.

[Lost]

Hrmmm...you will have to set up an array:
(replace 'SOMETABLE' with your table and change the conditional statement as necessary)


$catinfo = mysql_fetch_array(mysql_query("select * from SOMETABLE where SOMEFIELD="somevalue"));


Then use a foreach loop to add them up:
(replace 'amount' with the field of the table in which the number value is location)


$total = 0;
for($catinfo as $cat)
{
$total += $cat[amount];
}
echo "Total: $total";

[darkcarnival]

well heres the thing i wont know the know the name of the cateogries. it will be like adding a category and then drawing info from that that cateogry in the DB. not sure if anyone understands this but if you think u can help me better via IM feel free to add me to your list. i have all of them but i currently just use msn & AOL

[Lost]

So you have a MySQL table with a name and fields with names. You want to add entries to the table with any values and be able to extract those values without knowing any of them but the table and field names?

I am offering help on this if you can give me a little better explanation. Please drop me an email at kevin@premonitionstudios.com