COUNT(*) returning 0 ?

COUNT(*) returning 0 ?

El Forum
Unregistered

#12

10-20-2009, 08:57 AM

[eluser]codex[/eluser]
I'd say loose the spaces. As you can see it screws up the queries:

Code:
`Transaction` Status

[quote author="dplgngr" date="1256068473"]@codex

It returned this error:

Code:
A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Status 'Settled Successfully' AND `Settlement` Amount '9.95'' at line 3

SELECT COUNT(*) AS total_count FROM (`authorize_net`) WHERE `Transaction` Status 'Settled Successfully' AND `Settlement` Amount '9.95'

Yes the fields are exactly like that. Check the screenshot below.[/quote]

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