Jump to content

forum news post to main site


crawlerbasher

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

Archived

This topic is now archived and is closed to further replies.

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