how display posts only one forum ?

[roxxx]

how display posts only one forum ?

How will be query ?

[nexialys]

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]

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


"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

"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"