You are here: Re: Quicker calculations on MySQL « All PHP « IT news, forums, messages
Re: Quicker calculations on MySQL

Posted by Joseph Melnick on 09/27/52 11:17

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@given.com> wrote in message
news:j7_me.2891$cN2.920@newsfe4-gui.ntli.net...
> 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
>
>
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация