Selecting from 3 tables at once

[Archbob]

$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";

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)).

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?

[Daijoubu]

http://dev.mysql.com/doc/mysql/en/pr...ith-alias.html
No aliasing in WHERE clause?

And btw, what error does it report? Use mysql_error() on it

[Archbob]

There's no error in it, it just comes up blank because c.articleidentifier=a.ID and b.userID=a.authorid specifies both those conditions have to be met whereas I want it to select if only the second one is met. I need it to pull information from all three tables though.

However, if I take out the first, then it selects the same entry like a billion times. Not sure what to do.

[Daijoubu]

How about

SELECT * FROM b_articles AS a, b_posts AS c
 LEFT JOIN b_users b ON (b.userID=a.authorid)
WHERE c.articleidentifier=a.ID 

[Archbob]

Thanks.

I'm not used to Left Joins.