Posted by Tom Rogers on 04/22/05 01:49

Hi,

Friday, April 22, 2005, 8:03:06 AM, you wrote:
RA> Hi again,
RA> Am faced with a new problem (either that or working straight 10 hours is
RA> catching up!)

RA> Heres my table (easy to figure out so i wont waste your time explaining the
RA> fields):
RA> cno,
RA> date_added,
RA> pic_name,
RA> pic_size_kb,
RA> pic_desc_text,
RA> pic_category

RA> the way i am displaying the data is like this (thanks to Phillip and Andy
RA> from this list)

RA> __________________________________
RA> category here 2pics, 90kb |
RA> ---------------------------------------------
RA> | pic-here | <pic_desc_text> |
RA> | pic-here | <pic_desc_text> |
RA> __________________________________
RA> category here 2pics, 160kb |
RA> ---------------------------------------------
RA> | pic-here | <pic_desc_text> |
RA> | pic-here | <pic_desc_text> |
RA> ---------------------------------------------

RA> When I sql the DB I call it like this: select picture_name<,more
fields>> from <table> where cno=<x> order by category.

RA> Any ideas as to how i get how many pics per category and size per category?
RA> I'm not sure if its a PHP thing or a MySql thing...

RA> Last problem for the day...then i hit the sack!
RA> Thanks in advance,
RA> Ryan


Something like

SELECT COUNT(pic_name) as pic_count, SUM(pic_size_kb) as pic_total
FROM pic_table GROUP BY pic_category

--
regards,
Tom

• Next in forum: How to save a file with UTF-8 encoding and no BOM using PHP?
• Prev in forum: PHP4 to PHP5 upgrade help
• Thread view: Re: [PHP] Count totals (might be 0T)

[Reply to this message]