Saving files

query string related

[iceotope32]

I am building a website which will have things such as news, etc. And my query strings will look something like this, website.com/Story.asp?S= for the category section, website.com/Category.asp?C= and so on and so forth. I already have the ASP code to pull information off of the database, the problem is, is that I don't know exactly how to store the news stories, etc.

Would I write them in a text file, or an html file then save it in the database for it to open and display, depending on what news story and or category a visitor has choosen? I was talking to someone the other day and they mentioned something about ADO, when I tried to read the tutorial on WC3school' website, I could barely wrap my mind around it. Is there possibly a simpler way of doing this? I've had this website for a while and just recently took it offline to transfer to a new domain that offers more space, at a cheaper price. And decided to give the site a face lift and build it differently, I.E. no more .html, I want to step up my skills alittle more. I have basic knowledge in ASP, PHP, HTM, HTML, and XML. The whole new site is now ASP and right now I'm hoping to work with an access database, I download MySQL but since I'm new to that, it's kind of giving me a headache. :)

Thanks!

[scraptoft]

I only have experience with MySQL but what I do is write the article out in dreamweaver so it creates the html code for me - <p> tags, urls, bold text etc. Then I simply copy & paste the article into a 'TEXT' (not varchar etc) field in MySQL.

Aswell as the article field I have a title, date and caption field to allow more flexibility.

[ergophobe]

Honestly, having built a few similar custom sites for myself, I find that the current crop of free CMS are good enough that there is just no compelling reason to go through that work.

Check out Drupal, Joomla, Wordpress and things like that. It will save you a lot of trouble (unless there's something I'm missing in your specs).