[Resolved] counting table columns

[BEFOR]

I have six columns in a table "P" and need to echo the total # of columns that only contain values. (not concerned about actual values contained, only if they do contain a value)

ex: if 3 of these contain a value then "3" should be echoed

col's
P1, P2, P3, P4, P5, P6

Would rather not use Count if it means javascript or a page refresh.
Any help much appreciated.

Can't this be done with <?php if( ( )) {echo' ' ;}?>

But how might it go to translate !='' to tally a total?

[bradgrafelman]

Once you ran your query to select the rows you want, try this:

while($result == mysql_fetch_assoc($query)) {
$counter = 0;

if($result['P1'] != "") $counter++;
if($result['P2'] != "") $counter++;
if($result['P3'] != "") $counter++;
if($result['P4'] != "") $counter++;
if($result['P5'] != "") $counter++;
if($result['P6'] != "") $counter++;

echo "There were $counter non-empty fields.";
}

[BEFOR]

thanks bradgrafelman,

Since only single row per result, was able to do with:
(with numbers less than ten meaningless as far as actual values)

<?php

$counter = 0;
if($row_cat['P1'] >=10) $counter++;
if($row_cat['P2'] >=10) $counter++;
if($row_cat['P3'] >=10) $counter++;
if($row_cat['P4'] >=10) $counter++;
if($row_cat['P5'] >=10) $counter++;
if($row_cat['P6'] >=10) $counter++;{echo "$counter";
}
?>