Re: Quicker calculations on MySQL
- From: "Joseph Melnick" <jmelnick@xxxxxxxx>
- Date: Tue, 31 May 2005 14:40:52 -0400
Hello Brian,
If you want to add the values in a number of columns:
create a query like this
$ch == 'n'
$ch == 'u'
($ch != 'n') && ($ch != 'u')
select sum(IF(ch='n',1,0))
notrecognisedcount,
sum(IF(ch='u',1,0))
discontinuedcount,
(count(1)-sum(IF(ch='n',1,0))-sum(IF(ch='y',1,0))) validorderscount
from table
This type of query may give you what you are looking for directly without
having to loop through
each record and go though lots of external logic to get your info from the
database.
If I understood the tables that you are working with then it would be an
easy matter of using writing a better query.
I hope that this helps.
Joseph Melnick
JM Web Consultants
http://www.jphp.com
Joseph Melnick
"Brian" <not@xxxxxxxxx> wrote in message
news:j7_me.2891$cN2.920@xxxxxxxxxxxxxxxxxxxxxxx
> Hi all
>
>
>
> I'm running a query in a PHP script. At the moment I have having to run a
> while ($myrow = mysql_fetch_array($result)) {...
>
>
>
> As it loops though is has to add up a number of columns, is there a
> quicker sql statement then doing this the following
>
>
>
> if ($ch == 'n') {
>
> $notrecognisedcount = $myrow[ord];
>
> }
>
> if ($ch == 'u') {
>
> $discontinuedcount = $myrow[ord];
>
> }
>
> if ( ($ch != 'n') && ($ch != 'u') ) {
>
> $validorderscount = $myrow[ord];
>
> $delivered = $myrow[del];
>
> }
>
>
>
>
>
>
>
> Brian
>
>
>
>
.
- References:
- Quicker calculations on MySQL
- From: Brian
- Quicker calculations on MySQL
- Prev by Date: html validator webservice
- Next by Date: Re: html validator webservice
- Previous by thread: Re: Quicker calculations on MySQL
- Next by thread: html validator webservice
- Index(es):
Relevant Pages
|
