Quicker calculations on MySQL

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