For my historic bridge website, I would like to create a search program which searches a predetermined database (.csv file) for a variety of things and will display the bridges (and small pictures of the matching bridge) that match the criteria on another page, linking back to the pages for the bridges. In addition, I would like to have pages for certain categories such as builder where I would describe it, and a program of sorts would pull out of the same database and generate a list of random bridges that are in that catagory (including pictures).
My questions are: What program would work for this (I am assuming perl) which I could create a search program to search with an "and" search and would be capable of searching through many different categories?
How would I add pictures to be displayed on the results and random page?
Creating the search criteria page, I would prefer drop boxes. How could I do this?
How would I hook up the second part (extra pages) to have displayed a random series of bridges from the .csv file? Would this take an additional script?
Any help would be greatly appreciated! I just need to know what my options are, no codes right now. I will work on that at a later date.