Counting for specific fields that aren't null

[tommy2shoes]

Hi

 

I have a table (applicant) that has a number of fields but included are:

applicantid

party1

party2

party3

party4

party5

 

Any number of these party entries could have data in them but I need to know, for any specific applicantid, the count of how many non null entries there are.

 

I can't find a way to do it.

 

Does anyone have any ideas.

 

Many thanks

[ted_chou12]

$array =array( "ap1" => "1",
"ap2" => "",
"ap3" => "0",
"ap4" => "",
"ap5" => "test");
$i=0;
foreach ($array as $key => $val) {
if ($val != "") {$i++;} }
echo "number of non null entries is $i";

?

Ted