Ok basically I want the select to select all articles from b_articles and display the article(which is in the articles table, the author(in users table), and display the thread relating to the article(in posts table)).
$getarticles="SELECT * from b_articles as a, b_users as b,b_posts as c where c.articleidentifier=a.ID and b.userID=a.authorid";
If there are no threads, then give option to start a thread.
However, this query is not working, its turning up blank. It was working fine until I add the third table into the query. Can anyone tell me how to do this correctly?