- Table phpbb_posts 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 phpbb_posts_text 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?
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!