COUNT(*) returning 0 ?

COUNT(*) returning 0 ?

El Forum
Unregistered

10-20-2009, 06:58 AM

[eluser]dplgngr[/eluser]
I get a 0 when i tried to use COUNT to retrieve the number of data.

Code:
$query = $this->db->query('SELECT COUNT(*) AS total_count FROM `authorize_net` where `Transaction Status` = "Settled Successfully" and `Settlement Amount` = 9.95');

$row = $query->row_array();

echo $row['total_count'];

the result printed 0 whereas when i query it using the phpmyadmin it returned the right amount.

Can anybody help me with this asap?
Thanks!

Messages In This Thread

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 06:58 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:11 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:23 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:25 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:40 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:43 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:50 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:10 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:32 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:38 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:54 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:57 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:06 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:12 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:22 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:31 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:33 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:40 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 10:08 PM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 10:16 PM