SQL Query works, PHP doesn't like it

[Minklet]

I have a join of 3 tables, I need to count the results for pagination. It works perfectly if I type it into phpmyadmin, but tells me I have an error in my syntax when I put the exact same query into PHP.

 

SELECT COUNT (*) FROM our_audio AS e
JOIN wp_site_posts AS p ON e.post_id = p.post_id
AND e.site_id = p.blog_id
JOIN wp_blogs AS b ON e.site_id = b.blog_id

 

 

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 '*) FROM our_audio AS e JOIN wp_site_posts AS p ON e.post_id = p.post_id AND e.si' at line 1 in /var/www/vhosts/subverb.net/subdomains/dev/httpdocs/podcast.php on line 64

 

 

Obviously it's hard to debug because I can't see why it would work if it was wrong?

[Minklet]

There was a space between the opening paranthesis after COUNT. Doh!