Re: Count totals (might be 0T)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, April 21, 2005 3:36 pm, Ryan A said:
> 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.

<?php
  /*
  category_count.inc
  Provides $CATEGORY_COUNT and $CATEGORY_SIZE variables for the application.
  */
  $query = "select cno, count(*), sum(pic_size_kb) from <TABLE> group by
cno";
  $cat_info = mysql_query($query) or die(mysql_error());
  $CATEGORY_COUNT = array();
  $CATEGORY_SIZE = array();
  while (list($cno, $count, $size) = mysql_fetch_row($cat_info)){
    $CATEGORY_COUNT[$cno] = $count;
    $CATEGORY_SIZE[$cno] = $size;
  }
?>

Only problem is that you could have a slight "timing" issue where the
select above gets done, then somebody adds a new image, and then you
display your counts, and then you display the list, and that extra image
is in the list, but not counted.

You *COULD* solve this by wrapping a transaction around the whole mess if
it's really critical, but you probably don't need it.



> Thanks,
> Ryan
>
>
> On 4/22/2005 12:08:31 AM, Drewcore (drewsph@xxxxxxxxx) 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@xxxxxxxxxxxx> 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
Like Music?
http://l-i-e.com/artists.htm

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux