The PaSoft Community

Index | Members | Register | Login | Logout

SELECT threads.*, u1.username AS author, u2.username AS lastposter FROM threads, users AS u1, users AS u2 LEFT JOIN posts ON posts.threadid=threads.id WHERE u1.id=threads.userid AND u2.id=threads.lastuserid AND threads.id=7 GROUP BY posts.threadid Unknown column 'threads.id' in 'on clause' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sarev0k/public_html/forums/objects/database.php on line 107 This thread does not exist Rendered in 0.006 seconds.