I have created a web site that is meant to be a journal article data base on a specific topic ( www.ccaretta.com). I origionally started off (with my little knowledge) making a new HTML document for every article citation and then used FreeFind as a search engine for all the article pages. I have many hundreds of articles and I now realise that this was a bad idea and WAY too much work for something that there should be a simipler system for - I just don't know which code to turn to.
The fields I have for each article are: reference, abstract, and link (to full text article). I would like to be able to enter information into these fields in ONE database then upload that database to my server. Then when someone searches the database for an artice they are presented with a list of references from the database that meet the search criteria. They can then click on a reference and a page will come up that displays all the fields for that reference. The page that they are displayed on would be like a frame (or similar) where I would only need to format one page which contains the fields in the database that are replace with data from the database depending on the reference selected.
Does a system like this exist? Can anyone point me in the direction of a code system (like PHP or Flash) that may give me similar result and make my database more functional and manageable and reduce my load to one "frame" document and one database? I would really appreciate any sugestions! Thank you! 
|