SceamingMonk Posted May 12, 2009 Report Share Posted May 12, 2009 (edited) Hi, I am a total newb with only some experience of html. I am ambitious about creating an interactive website and I have the basics down for doing this. However, my proposed page is going to contain listings for events that will need to be added and updated regularly. Rather than go in and change each listing individually, I want to rely on a template which will automatically be updated from a database / spreadsheet. For instance, I want the web page to list something like the following information: Film: Star Trek Cinema: Odeon Times: 19:30, 20:30, 21:30 Review: [include url] Trailer: [embedded youtube video] etc... In this example I would want all movie listings to follow the same format but for each one to be linked to a db so that I can simply update the fields there, rather than go in and edit the code directly. Is this something I can do using SQL? Or is there something more appropriate? I do want to the appearance to be dynamic. I know this seems ambitious for a newb but I'm simply planning ahead. My early versions of the page will be updated manually but, ultimately, I want to be able to make quick updates in this way as I plan to be handling a lot of information. Many thanks!! SM Edited May 12, 2009 by SceamingMonk Quote Link to comment Share on other sites More sharing options...
jlhaslip Posted May 12, 2009 Report Share Posted May 12, 2009 Very do-able. You might want to look at a Content management System for this. Most of them use MySql and PHP for the dynamic portions. Quote Link to comment Share on other sites More sharing options...
LSW Posted May 12, 2009 Report Share Posted May 12, 2009 You will always use something SQL based to query the Database. SQL (SQL), MySQL (MySQL), T-SQL (SQL), SQLPlus (Oracle)... Then off the wall stuff like "Hybernate" that make up their own languages... still make up their own versions of SQL. Quote Link to comment Share on other sites More sharing options...
SceamingMonk Posted May 12, 2009 Author Report Share Posted May 12, 2009 Thanks, this is what I suspected - can anyone point me in the right direction for a good SQL tutorial which would cover this? Quote Link to comment Share on other sites More sharing options...
jlhaslip Posted May 12, 2009 Report Share Posted May 12, 2009 Start with this one: http://www.killerphp.com/mysql/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.