eth3l Posted March 15, 2003 Share Posted March 15, 2003 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 More sharing options...
0 wildliquid Posted March 15, 2003 Share Posted March 15, 2003 i too would like to know this Link to comment Share on other sites More sharing options...
0 Ash Posted March 15, 2003 Share Posted March 15, 2003 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 More sharing options...
0 wildliquid Posted March 15, 2003 Share Posted March 15, 2003 it looks like he is using phpbb, im using invision Link to comment Share on other sites More sharing options...
0 ad.J Posted March 15, 2003 Share Posted March 15, 2003 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 More sharing options...
0 eth3l Posted March 15, 2003 Author Share Posted March 15, 2003 the forum is at www.lowreview.com/forum its php 2.0.2 is about all I know . . . I did not customize anything ;) Link to comment Share on other sites More sharing options...
0 ad.J Posted March 15, 2003 Share Posted March 15, 2003 the forum is at www.lowreview.com/forum its php 2.0.2 is about all I know . . . I did not customize anything ;) Yup, me too. Link to comment Share on other sites More sharing options...
0 Ash Posted March 15, 2003 Share Posted March 15, 2003 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 More sharing options...
0 wildliquid Posted March 15, 2003 Share Posted March 15, 2003 its funny how that happens... well thanks for helping :D Link to comment Share on other sites More sharing options...
0 eth3l Posted March 15, 2003 Author Share Posted March 15, 2003 Ash - Thanks - so I just put that code in my .asp file whereever I want it? Link to comment Share on other sites More sharing options...
0 Ash Posted March 15, 2003 Share Posted March 15, 2003 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 More sharing options...
Question
eth3l
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