HELP: display images from a post in FORUMHOME

[dannylin3000]

I'm running a photos forum. Here's what I'd like to do:

- display thumb of the first photo posted in a specified forum in my FORUMHOME
- all photos posted were using the [ img ] bbcode

Anyone know how to do?

Danny

anyone can help?

I'm looking for a coder to help to implement some modules for my site (can be also very useful for some others).

here's my site: http://DearPhotos.com

[dannylin3000]

anyone can help?

Can anyone shed some light on this?

I do have a field called "goodnees" added in the table 'thread'.

If goodnees = 6, then it should be shown in SHOWTHREAD (category best)
If goodnees = 7, then it should be shown in FORUMHOME (best selected)
If goodnees = 8, then it should be also shown in FORUMHOME in a special block (Site Best)


Here's a SQL command I'm trying to compose:

SELECT `title`, `postusername`, `threadid`,`forumid`,`goodnees`
FROM `thread` 
WHERE `forumid` IN ('8','9','10','11','12','33') AND `goodnees` >=6
ORDER BY `thread`.`forumid` ASC 
LIMIT 0 , 6

What should I do next? Apologize, I'm not so familiar with SQL and PHP.

[dannylin3000]

bump

[dannylin3000]

Anyone?

[dannylin3000]

bump