SELECT a.comment_id, a.name, a.email, a.comment, a.live, b.article_name, b.article_id, c.article_id, c.comment_id, c.commentjuke_id FROM comments as a, articles as b, connect_commentarticles as c WHERE c.article_id=\'$id\' AND a.comment_id=c.comment_id AND a.live=\'1\'";Basically, Comments for articles are stored in one table. Articles content is stored in the other, and the third table pulls the two tables together (only three columns, for the article id, the comments id, and it\'s own id). I just want to pull the tables together but keep getting an error.
NOTE: the variable \"$id\" is the article id, that will be submitted by the user.
Please let me know if you can help!