Can't combine 2 queries

[V]

I've been struggling to combine 2 queries but I keep getting errors. They are..

 

"SELECT topics.*, categories.* FROM topics, categories WHERE topics.cat_id = categories.cat_id AND topics.views >= 2 ORDER BY topic_date DESC";

 

and

 

"SELECT *, COUNT(post_id) as total_posts FROM posts WHERE topic_id = {$row["topic_id"]} ORDER BY post_date DESC";

 

Is it even possible to combine them? Pls help.

[grissom]

try :

 

... ORDER BY topics.topic_date DESC

 

lemme know if that works

[Mchl]

What's the relation between posts table and two other tables?

[V]

grissom, hmm I'm not sure where to add that, I'm trying to figure out how to combine the 2.

 

Mchl,

 

In the first query, the Topics table are like subcategories of the Category table. Each Category as a number of Topics.

 

topics.views >= 2 is the unique views of a topic  (for a "sort by") script I wrote. So I'll also have for example topics.comments >=5 for most commented. Combing the 2 queries would be ideal because I can query just once for each condition. 

 

And the second query tells the total number of posts that are in a topic. So both should echo out

 

Topic Name        .......          Category (it belongs to)          ...........          Total Number of Posts

 

Hope that makes sense