After heading over to mysqlfreaks for help and finding the forums shut down I've been redirected over here.
I'm having a problem with MySQL versions. I run MySQL 5.0.21-community-nt on my localhost for development and my web sites server runs MySQL 3.23.58. Until now this hasn't been a problem.
Having used the following SQL statement on my localhost and having it return correct results.
SELECT distinct a.articleid, a.articleauthorid, a.articletitle, a.articlecontent, a.articledate, a.articleenclosuretitle, a.articleenclosureuri, a.articleenclosurelength, u.userid, u.username, u.userstatus, (SELECT COUNT(*) FROM comments WHERE comments.articleid = a.articleid)AS articlecomments FROM comments c, articles a, users u WHERE a.articleauthorid = u.userid ORDER BY articledate DESC LIMIT 0,3I updated my website to use the new SQL with no luck. My web site's MySQL server gives me the following error:
#1064 - You have an error in your SQL syntax near 'SELECT COUNT(*) FROM comments WHERE comments.articleid = a.articleid) AS articlec' at line 1
My question is how would I replicate the same results of the above statement for my web sites server?
If anymore information is required just let me know. Thanks in advance.