Comments

(To click on comment, use the “Recent comments” box in the left sidebar)

Comment                                        Story                                      Commenter

(left column)                               (middle column)                            (right column)

$result = db_query('SELECT c.subject, c.timestamp, n.title, u.name, u.uid, n.nid FROM comments AS c
INNER JOIN users AS u ON c.uid = u.uid
INNER JOIN node AS n ON c.nid = n.nid
ORDER BY c.timestamp DESC LIMIT 200');

print "n

n”;
while ($r = mysql_fetch_assoc($result)) {
print ”
“;
#print “

“;
print “

“;
print “

“;
print “

“;
print “

n”;
}
print “

{$r['timestamp']}

{$r['subject']}

{$r['title']}

{$r['name']}

n”;
?>

—– You can also view the Latest 1000 Comments —–