I finally got my PHP add/edit form to work. While
working on it, it occurred to me that I could use it
to post and modify more than bits of data in tables. I
could use it to make pages that people with no web
design skills can add articles to.
Most of my post focuses on PHP; my main question
regarding MySQL is this: Is it a good practice to use
MySQL databases for entire articles? By "article," I
mean anywhere from two to over 100 paragraphs, along
with HTML coding and perhaps some images.
I know I haven't invented the wheel; I'm sure people
are already doing this or using a similar method. I'm
just new to this "content management" stuff, so I'm
just learning the ropes.
Anyway, this is my plan:
Suppose I put 50 pages focusing on the 50 states
online. But each page's body section is empty, except
for a link to a single cell in a MySQL table. The cell
corresponds with a field named "Articles," and an echo
statement in the page's head section further specifies
a state (or row), such as Alaska.
Thus, a client could write an article about Alaska,
insert a couple images, then copy the HTML.
Next, he would access my add/edit page, click the
Alaska row and find the "Articles" cell/field.
Then he would paste the article into the cell and
submit it. He effectively created a web page focusing
on Alaska without REALLY creating or uploading a page.
Does this sound like a good idea, and is MySQL up to
the task?
Thanks.
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
