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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to