Re: Quicker calculations on MySQL

Try

GROUP BY ord
http://dev.mysql.com/doc/mysql/en/select.html

SELECT *,count(ord) AS CountOrd FROM tbl_name
GROUP BY ord

CountOrd would then contain the total counts of the variables within ord
--
----------------------------------------------------------------------------
http://www.clickonlingerie.com?SIG - Exotic Erotic Lingerie
----------------------------------------------------------------------------


"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
>
>
>
>


.

Quantcast