[CommuneZoom]

Originally Posted by Danny.VBT

Try the below, maybe it will work. I need to start coding php more, and stop with vb.net. I'm starting to forget stuff!

PHP Code:

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


Thanks for the reply, however, I need them both to be showing at the same time and not alternating.

As I need it to report the total for the entire table, the above will not work. I have 8 entries in the table and the above reports a blank for active and 1 for pending (when all 8 are pending).