Technology, Support, and News Forum

[kanaloa]

php question for ya.

I have this line in phpbb:
$topic_sql = "SELECT t.topic_id, t.topic_title, t.topic_replies, t.topic_views, u.username, u.user_id FROM phpbb_topics t, phpbb_users u WHERE t.forum_id = $forum_id AND t.topic_poster = u.user_id ORDER BY topic_last_post_id DESC LIMIT $limit";

And all I want to do is include this variable: f.forum_name

Problem is that is comes out of the phpbb forums table "f". How can I make the above line pull that variable so I can get the forum's name?

Thanks for any help you can provide on that snippet.

[jbullard]

What you have to do is setup an alias name for that table in your SQL statement. I am guessing "f" stands for forum so it would be something like this

$topic_sql = "SELECT t.topic_id, t.topic_title, t.topic_replies, t.topic_views, u.username, u.user_id, f.forum_name FROM phpbb_topics t, phpbb_users u, phpbb_forums f WHERE t.forum_id = $forum_id AND t.topic_poster = u.user_id ORDER BY topic_last_post_id DESC LIMIT $limit";

You also need to setup a WHERE clause which would be, I believe in the topics table it is still labeled as forum_id. So you would also need to add to the WHERE clause

$topic_sql = "SELECT t.topic_id, t.topic_title, t.topic_replies, t.topic_views, u.username, u.user_id, f.forum_name FROM phpbb_topics t, phpbb_users u, phpbb_forums f WHERE t.forum_id = $forum_id AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id ORDER BY topic_last_post_id DESC LIMIT $limit";

HTH