i am working on a website at the moment www.realitycheck.tv and the next stage is to run all the content off of a database, my main question is how to attach the video's (all video's will be in 3 formats). would it be to put a field in which would say the file name - and a php script could then turn this text into a file location/link on the actual page?
also there are some large area's of text - the questionaires used etc, these will be in pop-up windows. would it be best to include the full text in the databse or have the questionaires stored some other way?
I'm using PhpMyAdmin to do this, as i am new to databases, but there was no way i was going to make 1000 individual html pages.