|
Posted by Brian on 10/05/11 11:17
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]
|