PDA

View Full Version : HELP: display images from a post in FORUMHOME


dannylin3000
05-21-2007, 12:20 PM
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
05-22-2007, 11:07 PM
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
05-25-2007, 03:13 AM
bump

dannylin3000
05-29-2007, 12:36 PM
Anyone?

dannylin3000
06-03-2007, 12:49 AM
bump