Hello everyone. 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.[code]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,3[/code] I updated my website to use the new SQL with no luck. My web site's MySQL server gives me the following error: [code]#1064 - You have an error in your SQL syntax near 'SELECT COUNT(*) FROM comments WHERE comments.articleid = a.articleid) AS articlec' at line 1[/code] 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. dtgreenwood.