• 0

PHP Forum help


Question

I am a **novice** web designer and learnt .asp as I went. I run a small web page with a small forum. I want to drive more traffic to the forum by having a "most recent forum posts section as Neowin and other pages do.

How do I do this and can anyone assist me?

thanks

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

Suggestion : Provide a list of relevent info... like perhaps what forum software your using if its not a custom one... if it is you should list the tables and fields in your databases that relate to posts.

This will better help people to know what your working with.

Link to comment
Share on other sites

  • 0

Errr... I would like to know this as well. I have no experience with PHP whatsoever. I installed phpBB2 with no problem, but I have no clue how it's done. I jsut want the newest posts on the front pages.

Link to comment
Share on other sites

  • 0

K with invision board you would do this query

SELECT * FROM ibf_topics ORDER BY last_post DESC LIMIT 0,12

Now for phpBB, since its different then invision a bit.... try this it should work:

SELECT * FROM phpbb_topics ORDER BY topic_last_post_id DESC LIMIT 0,12

the "DESC LIMIT 0,12" in both lines tells it to make the order by descending order so that it will list the most recently posted on topics... the 0,12 makes it so it will show only 12 posts... so these queries give the last 12 posts posted in. you can change the 12 to whatever you want...

Hope this helps :) a few months ago it was me asking that question! its good to be able to now help others :)

Link to comment
Share on other sites

  • 0

Ohh hmm ya uhh hehe... thats a MySQL query. Those queries are for php and MySQL... can phpBB be installed on a server running ASP?

If so I would probably have to say that the query should still work... but I haven't worked with ASP much at all, you would execute it like any other query tho... you have to make the connection to the database, execute the query and display the results... how you do that specificly in asp, I wouldn't know... I though cause the topic was "PHP Forum help" you were working with this in php.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.