Query not retrieving rows with 0

[Eiolon]

I made a forum and it works for the most part.  The problem I have is when I query for the list of topics in the forum, anything with 0 replies does not get shown.  Once I have a reply to that topic it gets shown.  Here is the query:

 

SELECT t.*, r.*, DATE_FORMAT(t.topic_last_reply, '%c/%e/%Y %l:%i %p') AS convdate FROM topics t LEFT JOIN replies r ON (t.topic_id = r.reply_topic) WHERE t.topic_forum = ".$_GET['forum_id']." GROUP BY t.topic_subject HAVING t.topic_num_replies >= 0 ORDER BY t.topic_last_reply DESC

 

Thanks!

[fenway]

Two things: first, that's not the final query, echo the query as a string (after PHP variable interpolation).  Second, remove the having clause, and check the value of your field.

[Eiolon]

Sorry, I am a novice.  When you mean variable interpolation, what do you mean?  Like this?

 

// Query the database for topic and reply information.
$query_topics = "SELECT t.*, r.*, DATE_FORMAT(t.topic_last_reply, '%c/%e/%Y %l:%i %p') AS convdate FROM topics t LEFT JOIN replies r ON (t.topic_id = r.reply_topic) WHERE t.topic_forum = ".$_GET['forum_id']." GROUP BY t.topic_subject ORDER BY t.topic_last_reply DESC";
$topics = mysql_query($query_topics) OR die ('Cannot retrieve a list of topics.');
$row_topics = mysql_fetch_array($topics);

[fenway]

I mean echo $query_topics.