1

Topic: Extern.php SQL

Hello,
I want print via extern.php last 10 posts with their subjects but i dont know how to implement this sql queries.

select id, (select subject from topics where id = topic_id) from posts where id > ((SELECT MAX(id) from posts) - 10)

After execution this SQL we get 10 last subjects and last post ids. If someone could translate it to extern.php style it would be great ;-)

Regards

Re: Extern.php SQL

Why not to use this: http://punbb.informer.com/forums/extern … mp;show=10

3

Re: Extern.php SQL

It doesn't work properly at my forum. This is my forum http://forum.supermoto.pl and you can try. Some new posts are not included in extern file and thats the reason.

4

Re: Extern.php SQL

After migration from other forum system all old topic have first_post_id and this is the problem.

5

Re: Extern.php SQL

I rather call the feed, but since it's not working for you then you might have to query from the database. I'm a newbie for punbb too. So I'm not with the solution but waiting for some people idea too smile

Re: Extern.php SQL

jtd wrote:

After migration from other forum system all old topic have first_post_id and this is the problem.

All topics should have first_post_id. Why do you think it is the problem?