Jump to content

joels

New Members
  • Posts

    6
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

joels's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. [quote author=mtylerb link=topic=110815.msg448654#msg448654 date=1160252026] If you did want to post text from each post, then you'd save the topic_id to a php variable (in this case $somevar) and use something like: [code]<?php $sql = mysql_query('SELECT * FROM phpbb_post_text WHERE topic_id = "' . $somvar . '" ORDER BY post_id DESC LIMIT 0,1;'); ?>[/code] That should give you the last post in the specified topic. [/quote] the field 'topic_id' doesnt exist in the table 'phpbb_posts_text' - only post_id - thats why i get so confused. And if you look almost all the way to the bottom left, you will see the latest 3 news topics and their associated texts on complexityclan.com .
  2. Redarrow, it's similar to what you said, but I want it to display the whole post text of every topic in forum_id 1. A good example I found of what I want is at [url=http://www.complexityclan.com/]http://www.complexityclan.com/[/url]. Scroll down to the news part of the homepage. You can see that he uses the newest 3 topics from the Complexity Clan News area on the forums.  Thats exactly what I want. The scheme I am using is mysql.
  3. Trust me, I've already looked up and down the PHPBB hacks and mods...too complicated. I want a basic code...you know how phpbb can get.
  4. 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!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.