Count totals (might be 0T)

Hi again, Am faced with a new problem (either that or working straight 10 hours is catching up!) Heres my table (easy to figure out so i wont waste your time explaining the fields): cno, date_added, pic_name, pic_size_kb, pic_desc_text, pic_category the way i am displaying the data is like this (thanks to Phillip and Andy from this list) __________________________________ category here 2pics, 90kb | --------------------------------------------- | pic-here | <pic_desc_text> | | pic-here | <pic_desc_text> | __________________________________ category here 2pics, 160kb | --------------------------------------------- | pic-here | <pic_desc_text> | | pic-here | <pic_desc_text> | --------------------------------------------- When I sql the DB I call it like this: select picture_name<,more fields> from <table> where cno=<x> order by category. Any ideas as to how i get how many pics per category and size per category? I'm not sure if its a PHP thing or a MySql thing... Last problem for the day...then i hit the sack! Thanks in advance, Ryan -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.1 - Release Date: 4/20/2005