how display posts only one forum ?

[roxxx]

how display posts only one forum ?

How will be query ?

hum, you'll have to be clearer on this one, and use a basic english language... translation engines are horrible with small sentences.

[roxxx]

example: Programming Discussions
how display use query last 10 posts (post not thread) with Programming Discussions ?

[nico_swd]

PHP Code:

"SELECT * FROM ". TABLE_PREFIX ."post WHERE forumid = xx AND visible = 1" 


??

[roxxx]

yes, I tried same, but

forumid field is not into tables post

[nico_swd]

I see. And...

PHP Code:

"SELECT
    post.*
FROM
    ". TABLE_PREFIX ."thread AS thread,
    ". TABLE_PREFIX ."post AS post
WHERE
    thread.forumid = XX AND
    post.threadid = thread.threadid AND
    post.visible = 1
GROUP BY
    post.postid
LIMIT
    10" 


?

[roxxx]

thank you

[Eikinskjaldi]

that query wont show the latest 10.

You will need to add an order by post.dateline (or postid, I guess) desc at the end. Also, you should use join to join tables, not where

PHP Code:

"SELECT post.*
FROM ". TABLE_PREFIX ."thread AS thread,
JOIN ". TABLE_PREFIX ."post AS post
USING (threadid)
WHERE
    thread.forumid = XX AND
    post.visible = 1
ORDER BY
    post.postid DESC
LIMIT
    10"