[colicab-d]

PHP Code:

$showattach=$DB_site->query_first("SELECT attachment.attachmentid
                                   FROM attachment
                                   LEFT JOIN post USING(postid)
                                   LEFT JOIN thread USING(threadid)
                                   WHERE thread.forumid = 11
                                   ORDER by attachment.dateline DESC
                                   LIMIT 10"); 


iswhat i used however i got this error

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT attachment.attachmentid
FROM attachment
LEFT JOIN post USING(postid)
LEFT JOIN thread USING(threadid)
WHERE thread.forumid = 11
ORDER by attachment.dateline DESC
LIMIT 10
mysql error: Unknown column 'attachment.postid' in 'on clause'

mysql error number: 1054

Date: Monday 28th of April 2003 05:01:34 PM
Script: http://www.artorg.co.uk/cupboards/cupboards/10last.php
Referer:

have i done something wrong? or is it just not working lol