[Paul M]

I think the logic may be backwards in that, totalactive should be when ispending = 0.

Try ;

PHP Code:

$getcustomers = $db->query_read("SELECT ispending FROM son_customers"); 
 WHILE ($result = $db->fetch_array($getcustomers)) 
{ 
    if ($result[ispending]) 
    { 
        $totalpending += 1 
    } 
    else 
    { 
        $totalactive += 1 
    } 
}