I don't quite know where to post this, so feel free to move it
I'm working on a website where the news page grabs a feed from the forum news section. That works fine.
The problem I am having is that I want to show who posted each post, so I built this SQL query:
Code: Select all
SELECT phpbb_users.username FROM phpbb_users, phpbb_posts WHERE phpbb_users.user_id='$posterid'
It seems to work partly - i.e. there is only one post in there at the moment and it gets that username correctly. However, when you add another post from a different username, all the posts displayed on the news page all take that username.
Any ideas?