Database question

Hi :smiley:
I was wondering if anyone knew of a program that did this:

I run a reality TV site. And I want to have a page for every reality start / reality show… and archive it kind of. If I was to do this with every individual page, it will take forever. And it will be a pain to change layouts (if I have to) with all those pages.

So does anyone know of a program that does this that I can install? Preferbly PHP /MYSQL. It’s kind of like having a profile page (with email, avatar etc; ) on Kirupa Forum… but I don’t want to start a forum and then just register all those people… (It’ll probably be a big database at least 100-200+ members)

HELP! :slight_smile:

PHP/MySQL is a good tool for this, it’s called content management, basically what you want to do is store all of your information in the database in columns, say title, author, date, articletext, etc

And then you use PHP to withdraw this from the database and then output it into whatever layout you have just like if it were html.

look up some php tutorials :slight_smile:

is it really hard to learn/setup? Cause I dont have a lot of time as it is… lol

Nah, it’s not that tough, although I had an excellent teacher (through KirupaForum IRC :))

That was mySQL, PHP took a bit longer to learn, but I got a book and it really helped out (PHP By Example)

PHP by Example is one Awesome book. If I had to relearn php for some reason, I would definitely choose that book. Mysql - Read some tutorials and just play around with phpMyAdmin in your CPanel; it takes about an hour to learn the structures :slight_smile: