Ok.
I have a clearer picture now of where you are at the moment and where you want to go.
I am going to say a couple of things in order to keep you on the normal path most of us probably follow when starting out - you can deviate from all of these guides if you want, but be prepared to explain why you want to break them for the time being.
1 Don’t keep the binary data in your database, just store the file name for now.
When you can successfully argue with yourself and others why you should keep it in your database then you will have fully understood the benefits - and then you can do it, but most people just store the file name.
large_image varchar(100) example “orbs-the-veil-is-lifting-large.jpg”
2 Try to re-use the title of the film as the name of the image, that way you can find it on your own file system and you have a naming convention you can follow.
3 Don’t try and do everything at once.
Make a really simple sample system on which you learn, and then add fields once you have grasped the main concepts and got a simple skeleton sample working to your satisfaction.
4 Don’t try and store display information in your database row definitions. eg
Footer_movieinfo TEXT NOT NULL
That is bad practice, just call it something which drops the display information “Footer_” etc
What happens if you move that info into a left hand channel on your website? - you will have to change your database otherwise that info is misleading.
So, make a simpler skeleton system for now, something which contains fewer fields, but should give you enough to get your teeth into.
test_films <- table name
=======
id INT AUTO-INCREMENT
film title VARCHAR 100
release_date date
large_image VARCHAR 120
summary VARCHAR 255
description TEXT
Go ahead and Populate that with say, 3 films’ data - make the dates 3 months, Dec 2009, Jan 2010 and Feb 2010.
This becomes your playground upon which you can then build the supporting PHP pages.
I have suggested you have a unique ID field in your table which auto-increments so that each time you add a new film this will assign the next number up.
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
Ok, then create a folder on your localhost server and put a file in it which retrieves just the id and title of each of your 3 test films.
Loop through that list and echo them onto the page in a UL
This will make a menu of available films.
Make each of those links in the fashion:
<li><a href="index.php?id=1">Orbs the veil is lifting</a></li>
To achieve the above you will have to connect to your database, loop through an array of results and use PHP to output HTML.
Don’t worry about creating correctly formed HTML at this stage.
Now, put in some conditional code which detects that $_GET[‘id’] has been set and echo a different message onto the page, which contains say, the title, summary and image of the film.
Come back if you get stuck, or search around on this forum for answers.
