MySQL to Flat-File
Posted: Sun Nov 24, 2002 8:46 am
Hello!
I've never done a lot of databases before, so I'm a bit new to them in general, but I have a good programming sense and knowledge. I am working on a contract script right now for a company who keeps track of all news headlines with their company name in them so the Media/PR department can quickly respond to the press regarding certain issues. I've got most things worked out, but a fairly simple question.
One major option in the script is to search the database for articles on certain dates, by categories, keywords, etc. If the database is going to be fairly large database of stories. When searching for stories...what is the easiest way to list the stories? For example....is there an easy way to develop the output HTML (just the story name for example), then continue searching the database? Or can I just go through the entire database while printing out the headlines in a flat txt file, then use PHP to render the text file and display the headlines 10 per page. Is that redundant?
I figure there is a way to just list the headline then continue searching the databse, or possibly have a flag field and if the story gets flagged, it gets outputted at the end.
Make any sense...any brief ideas? Thanks!
I've never done a lot of databases before, so I'm a bit new to them in general, but I have a good programming sense and knowledge. I am working on a contract script right now for a company who keeps track of all news headlines with their company name in them so the Media/PR department can quickly respond to the press regarding certain issues. I've got most things worked out, but a fairly simple question.
One major option in the script is to search the database for articles on certain dates, by categories, keywords, etc. If the database is going to be fairly large database of stories. When searching for stories...what is the easiest way to list the stories? For example....is there an easy way to develop the output HTML (just the story name for example), then continue searching the database? Or can I just go through the entire database while printing out the headlines in a flat txt file, then use PHP to render the text file and display the headlines 10 per page. Is that redundant?
I figure there is a way to just list the headline then continue searching the databse, or possibly have a flag field and if the story gets flagged, it gets outputted at the end.
Make any sense...any brief ideas? Thanks!