Closed Thread Icon

Topic awaiting preservation: display dedication message on main page website (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=12649" title="Pages that link to Topic awaiting preservation: display dedication message on main page website (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: display dedication message on main page website <span class="small">(Page 1 of 1)</span>\

 
shattered
Obsessive-Compulsive (I) Inmate

From:
Insane since: Feb 2003

posted posted 03-13-2003 01:36

Hi guys,
please look at this site http://www.ljdrama.org/ . (Caution, foul language)
Please look at "Recent Comments". This is what I'm trying to accomplish. Our group is going to build an online radio station, with a dedication system. The last 5 dedication would be displayed on the sidebar of our website.
Can anyone tell me what tools I should use? And if you can refer me to any references, that would be really great.
And I would like to thank you all for helping me out these past few days.
You guys are just great

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 03-13-2003 01:54

shattered: You need to just do a search of the database table which holds the comments and order it so the most recent is first and limit it to the number you want. As I presume you are using MySQL (and PHP) this is fairly staright forward but without knowing your database structure I can't really be more specific than that - search the MySQL manual for LIMIT and ORDER BY - its all pretty straightforward from there.

[edit I should add that I have done something similar on the front page here:
http://development.gurusnetwork.com

although for technical reasons the SQL is a little more involved than you should need so I won't drop it in here as it will confuse matters rather than make thm clearer]

Emps

___________________
Emps

FAQs: Emperor

« BackwardsOnwards »

Show Forum Drop Down Menu