Best way to serve up numerous articles?

anessa05 · 03-17-2006, 08:15 PM

Hello all,
I'm redesigning an asp site for an online magazine and am wondering what the best way to serve up the numerous articles would be. Currently; there are individual pages for each article. Each page uses includes for the nav, footer, and other elements used throughout the site. Is there a better/easier way?
Thanks in advance,
Anessa

degsy · 03-20-2006, 05:31 PM

Have one page called articles.
Include your article content via a querystring.

e.g. articles.asp?article_id=23

Have database code in your file to output the article data from the database according to the querystring.

Code:

article_id = Request.QueryString("article_id")
' do some validation here. Trim, IsNumeric, InStr(" "), Replace '  '' etc.
sql = "SELECT * FROM articles WHERE article_id = " & article_id