I wonder in that case what my problem is...
I issue the following query in phpMyAdmin:
PHP Code:
SELECT venue, SUM( amount )
FROM IWD
WHERE venue = 'Foxy Hollow'
And get this result:
venue SUM(amount)
NULL NULL
If I take away the single quotes, I get an error:
PHP Code:
#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 'Hollow' at line 1
SELECT venue, SUM( amount )
FROM IWD
WHERE venue = Foxy Hollow
If I have entries without spaces (for example FoxyHollow) the query works like a charm..
I guess I could convert the names to replace blanks with underscores.. but I'd rather not. :/
Edit: Damn it, id Didn't work.. but, now I really don't understant this.. it worked yesterday.. I HAVE made some changes somewhere, dut damn me if I could remember what.. there IS something wrong with the query.. my apologies... now.. I just need to find out WHAT is wrong with my query.. :/