Getting MySQL's JOIN to work -- Please Help

[Xenon]

hmm ok, then the long method

PHP Code:

$listreply = $DB_site->query("
SELECT post.*, reply.name as replyname, reply.subtitle as replysubtitle, reply.subtime as replysubtime, reply.message as replymessage, reply.hashid as replyhashid 
FROM hd_posts as post 
LEFT JOIN hd_replies as reply ON (post.id = reply.tid)
"); 

while($listreplies = $DB_site->fetch_array($listreply)) 
{ 

    eval('$viewreplies .= "' . fetch_template('viewreplies') . '";'); 

} 


and be sure as said $listreplies[reply....] is in your templates