Hi, I was wondering if someone could tell me how you specify a certain topic with it's text if its in two seperate tables on my database (phpBB). I have a section of my forums designated for admins only to post recent news, and I want the newest 5 topics to come up on my homepage as news tables, but I dont know the mysql code to associate the topic id with post text because it is on two seperate tables. So, here's the deal: [list] [*]Table [b]phpbb_posts[/b] has the fields post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, and post_attachment. [*]Table [b]phpbb_posts_text[/b] has fields post_id, bbcode_uid, post_subject, and post_text. [*]I want to have all topics in forum_id 1 to display on my homepage ordered by descending but without its associated replies. What is the mysql code to link this information? [/list] _________________________________________________________________________________ Structure for homepage news table: post_subject (the post's subject) post_text (the post text submitted) post_comments (how many replies) _________________________________________________________________________________ So how would I do this as far as MySQL coding goes? Let me know if you need more information. Thanks!