grab the latest attachment from certain forum id

[corsacrazy]

im looking for a small query to grab the latest attachment only jpg's in a certain forum id to be displayed on the home page possible ?

[corsacrazy]

the image should also link to the thread where it came from

[corsacrazy]

ok here is sumthin similar but i need to modify it

$attach=$DB_site->query_first("SELECT attachmentid,counter,filename FROM attachment ORDER BY counter DESC LIMIT 1");

i need to add a forum id there sumhow select from* forum id XXX

[assassingod]

I can't remember much of vB2 code, but try:

PHP Code:

    $attach=$DB_site->query_first("
        SELECT attachmentid,counter,filename,dateline 
        FROM attachment 
        WHERE forumid = 'x'
        ORDER BY dateline DESC 
        LIMIT 1"); 


[corsacrazy]

i get this error

PHP Code:

Invalid SQL:  
        SELECT attachmentid,counter,filename,dateline 
        FROM attachment 
        WHERE forumid = '24' 
        ORDER BY dateline DESC 
        LIMIT 1
mysql error: Unknown column 'forumid' in 'where clause'

mysql error number: 1054 


Originally Posted by assassingod

I can't remember much of vB2 code, but try:

PHP Code:

    $attach=$DB_site->query_first("
        SELECT attachmentid,counter,filename,dateline 
        FROM attachment 
        WHERE forumid = 'x'
        ORDER BY dateline DESC 
        LIMIT 1"); 


[assassingod]

Yeah - didn't think it'll work. I'll look into it

[corsacrazy]

im still trying and no luck any news assassin ?