RE: Count database-values

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

 



Edward,

Have you considered trying mysql_result()?

It appears that your query is going to always return a single piece of data:
Total. So you essentially have an array with only a single element. If you
did this:

$total = mysql_result($result,0);

You'll get the value of the item at index 0 (the first position in an array)
of the $result array stored in the $total variable.

Details are here:
http://us3.php.net/manual/en/function.mysql-result.php

The page also makes reference to other "high-performance" options, but since
you're only grabbing a single item and if you use the index number instead
of the column name as the documentation recommends, the performance should
be just fine.

Hope this helps.

Rich

> -----Original Message-----
> From: Becoming Digital [mailto:subs@becomingdigital.com]
> Sent: Tuesday, June 10, 2003 12:50 PM
> To: php-db@lists.php.net
> Subject: Re:  Count database-values
> 
> 
> Unfortunately, I can't, despite my best efforts, get the data 
> to display unless
> it's put inside a loop.  If anyone can tell me how to, I'd 
> just for joy.
> 
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
> 
> 
> ----- Original Message -----
> From: "Ford, Mike [LSS]" <M.Ford@lmu.ac.uk>
> To: "'Becoming Digital'" <subs@becomingdigital.com>; 
> <php-db@lists.php.net>
> Sent: Tuesday, 10 June, 2003 11:54
> Subject: RE:  Count database-values
> 
> 
> > -----Original Message-----
> > From: Becoming Digital [mailto:subs@becomingdigital.com]
> > Sent: 10 June 2003 12:15
> >
> > I screwed up my own code.  Silly me.  It should read:
> 
> Surely your first attempt is the right one?  There's only 
> ever going to be 1
> Total, so why waste a while loop trying to read more than one 
> result row?
> 
> > $query = "SELECT SUM(bedrag) AS Total FROM finance WHERE
> > posneg = 'af'";
> > $result = mysql_query( $query );
> > while ( $total = mysql_fetch_array( $result ) )
> > {
> >     $total = $total['Total'];
> > }
> >
> > Edward Dudlik
> > Becoming Digital
> > www.becomingdigital.com
> >
> >
> > ----- Original Message -----
> > From: "Becoming Digital" <subs@becomingdigital.com>
> > To: <php-db@lists.php.net>
> > Sent: Tuesday, 10 June, 2003 06:43
> > Subject: Re:  Count database-values
> >
> >
> > > So far no problems, but I want to count all these values.
> > > I tried with SUM but with the following code it doesn't work:
> > >
> > > $squery = "SELECT SUM(bedrag) AS Total FROM finance WHERE
> > posneg = 'af'";
> > >
> > > any suggestions how to do? I want to store it in a
> > variabele ($total)
> > > so I can echo it. (E.g.: $total = 93.63 in this case)
> >
> > If you want the total, you need to do something like the following:
> >
> > $query = "SELECT SUM(bedrag) AS Total FROM finance WHERE
> > posneg = 'af'";
> > $result = mysql_query( $query );
> > $total = mysql_fetch_array( $result );
> > $total = $total['Total'];
> >
> 
> Cheers!
> 
> Mike
> 
> ---------------------------------------------------------------------
> Mike Ford,  Electronic Information Services Adviser,
> Learning Support Services, Learning & Information Services,
> JG125, James Graham Building, Leeds Metropolitan University,
> Beckett Park, LEEDS,  LS6 3QS,  United Kingdom
> Email: m.ford@lmu.ac.uk
> Tel: +44 113 283 2600 extn 4730      Fax:  +44 113 283 3211
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux