View Single Post
Old 11-01-2005, 10:56 AM   #1 (permalink)
tiffn
Junior Member
 
Join Date: Jul 2005
Posts: 28
Default join two queries?

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
tiffn is offline   Reply With Quote
Sponsored Links