how can i count the filled cells/columns of a mysql row with PHP?

[surinder1984]

Kindly view the code:

<?php
include("../db.php");
$result = mysql_query("SELECT * FROM accounts WHERE id LIKE 7");
while($r=mysql_fetch_array($result))								{										$clientname=$r['name'];								$date=$r['date'];									$clentid=$r['id'];
$data1=$r['d1'];
$data2=$r['d2'];
$data3=$r['d3'];
$data4=$r['d4'];
$data5=$r['d5'];
$data6=$r['d6'];
$data7=$r['d7'];
$data8=$r['d8'];
$arr = array($clientname, $date, $clientid, $data1, $data2, $data3, $data4, $data5, $data6, $data7, $data8);
$count = 0;
foreach ($arr as $value) {
$arr = strlen($value);
if (strlen($value) <= 0){
$count ++;
}
echo $count;}
}
?>

how can i get the only number of number of columns/cells that are having values in it.
only NUMBER,,,
Suppose d1, d4, d5, d8 having value in it the result gies only number "4".

Hope anyone can give me solution for this....thanks in advance...

[johny10151981]

try this function mysql_num_field s