help with a forum

[ryans18]

I've got a forum set up and works but the only problem is that when i display the last poster and/or who posted the topic, i have it reading the usernames in my database. but for every username in the database it repeats the post (long story short it echo's every username instead of just the one that posted it)

 

it was a simple forum where you typed in your name and topic and then it would post which worked fine. but then i started changing it so it just used the username instead of typing in a name. so my question is when a user fills in the text box and hits reply how do i store that information in the database so when i retrieve it, it shows who actually posted the message?

 

(my database has a login table and a forum table) if you need to see any part of the code let me know. thanks in advance

[chronister]

Well, you need to tie the 2 tables together. Either add a field in the forums table to store the user id that posted it, or create a new table and have it store the user id and post id. Either way you need to explicitly tie the poster to the topic and then retrieve that information together.

 

Nate