[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.