database for articles

[The Literary Thug]

Hey guys,

Nice site, I found a lot of useful information on it. Thank you.

I'm in the planning stages of a site that will eventually have hundreds of articles (I mean to add content on a daily basis). I'm thinking a database is the way to go, but have never tried to link to one from a web page before. I have Solid, and I'm pretty sure I can do the actual creating of the database without too much trouble. It's getting it up on a server and activating it (is that the right term?), then linking to it from the web page that sounds scary. Do you have any advice or know of any pages that will walk you through this?

I see you have a tutorial for using Coldfusion in a form. I was wondering if you have or know of any good examples for using it for posting articles. Would you just create a table and do the call from inside of a cell or something?

Thanks for reading all of this;)

[Chris]

Honestly, I'd recommend using PHP for this not ColdFusion. You'll have an easier time finding it offered by a host and its faster.

You'll also be better off using a database server than a desktop database, so I'd recommend MySQL. Its what powers this site.

This thread http://www.websitepublisher.net/forums/showthread.php?threadid=101

Discusses PHP books, but specifically for you I'd suggest Kevin Yank's book.

http://www.amazon.com/exec/obidos/tg/detail/-/0957921810/qid=1059398804/sr=8-1/ref=sr_8_1/103-5483167-3405421?v=glance&s=books&n=507846

Or this one:

http://www.amazon.com/exec/obidos/tg/detail/-/0596000413/ref=pd_bxgy_text_1/103-5483167-3405421?v=glance&s=books&st=*

Both will teach you PHP & MySql. Both will show you how to build a database driven website.

Then all you'd need is a cheap $10 linux hosting account -- if you don't already have one.

[The Literary Thug]

thank you for the fast response and the links.