Re: Count totals (might be 0T)

Hey, Thanks for replying. That means I will have to run a query per category....which I would like to avoid if possible as they could be a high amount of categories as they are user created and not defined by us. Thanks, Ryan On 4/22/2005 12:08:31 AM, Drewcore (drewsph@gmail.com) wrote: > run another sql query: > "select pic_size_kb from <table> where > pic_category='$current_category", > then make a loop that increments a) > > the total number of records (ie total number of pics in category), and > > then adds the pic size from each record to some variable (eg > > $total_kb) and then you have your total. > > > > hope that helps. > > > > drew > > > > On 4/21/05, Ryan A <ryan@coinpass.com> wrote: > > > 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 -- 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