Date: 08/03/05 (WebDesign)    Keywords: html, database, web, yahoo

Hello, I am a long-time lurker to this community and have always found the advice given to other quite helpful in my webmastering/design endevors. I work for a local newspaper running their website, and have a small issue that I could really use some helpful advice on.
Any fingers pointing in the right direction would be much appreciated!


The newspaper website I run is looking to do some major much-needed updating, and implementing a "Top Jobs" database option is one of them. Much in the light of larger websites like Yahoo Hot Jobs, and even smaller newspaper websites such as Lawrence-Journal World (Kansas), we are looking to have some kind of rotating script/database that will pull randomly from our uploaded employment classifieds and display links to these ads on several pages of the website (in the designated "Top Jobs" display box that will be created and placed on these pages).

I am really lost on even how to begin this project, as it was most recently presented to me that this Top Jobs section should include ALL of the employment ads posted (which can number over 300 at times), and rotate them on a normal basis so that each one has airtime, several times a day. Doing all of this by hand would take DAYS!

What I believe we need is a server side internal database with a perl script written that would automatically pull these ads off the .shtml pages created for the employment classifieds. If you have any info on how to go about obtaining this, or know any information on how to even go about doing this (assuming I am incorrect)....please let me know!

I would be very greatful!

Source: http://www.livejournal.com/community/webdesign/945510.html