join two queries? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

tiffn · 11-01-2005, 09:56 AM

Hi,

What I have is the first query selects the information about the writers article, and the second query selects the comments about the article.

Code:

$id = $_GET['id'];
$query = "SELECT *
FROM writer_articles
WHERE id = $id
ORDER BY date_time DESC";

and the second

Code:

$query = "SELECT * FROM writer_comments
WHERE id = $id
ORDER BY date_time DESC";

I have tried putting FROM writer_articles, writer_comments in the same query but that doesn't work. I think it should be done with a join, but i don't understnad how to put it all together. Advice appreciated.
tia

websitedatabases · 11-03-2005, 07:12 PM

Give this a try:

Code:

SELECT * FROM writer_articles a
INNER JOIN writer_comments
c ON c.id = a.id
WHERE a.id = $id
ORDER BY date_time DESC