My friend who owns a video store asked me to help him design a site for his video store. One of the features of the site would be a searchable/browsable data base of all the movies that he has.
Currently, all the titles are stored on a program he uses at the register. I looked through it, and it seems that the way that it stores title info could not be extracted for anything else, so basically I have to start from scratch.
What would be the best way of doing this? I got one of his employees to start making alphabetical text files with each title being on a seperate line. I was thinking that later could use php to read the titles and put them into a mysql DB. one more thing, each title will have a link to the movie's description (if available) that will be a link to an external website...should this info be in the same file as the titles, or have a seperate corresponding file?
what do you guys think?