Jump to content

Recommended Posts

ok when it comes to php and mysql I am an amature at it.

This in it self has given me problems in trying to figure this out for my self, and there have been no good sorce of information when searching for it on google.

 

The problem is this.

I would like to have the same kind of contents thats on the forum in the news catagory dispalyed on the main page of the site, showing the last 10 entrys.

 

An exsample would be this:

 

Todays news (date and time)

Posted by Crawlerbasher

 

Contents 1

 

yestadays news (date and time)

Posted by Crawlerbasher

 

Contents 2

 

and so on for up to the last 10 topics posted in the news section.

So far I have manage to target the key structure of the database.

 

in the phpbb_forums

forum_id (in this case I'm after all contents related to id 1)

in the phpbb_posts

Post_id

forum_id

poster_id

poster_time

and in the phpbb_posts_text

post_id

Post_Subject

post_text

And finaly phpbb_users

user_id

 

But for the life of me I can't figure out how to get this all together.

The easy result would be to find a script some one made that dose this.

So I could intergrate it into my site or learn how he did it, and creat a personal one for my self based on that code.

 

I apprecate any of you that came forwold and offer there advise or and help.

 

Best Regards

Crawlerbasher

Link to comment
https://forums.phpfreaks.com/topic/84578-forum-news-post-to-main-site/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.