Dynamic Text in Web Pages

[TDC]

Hello, and thanks for reading this post.

As a complete beginner in developing a website I would simply like a little advice to make sure I am heading in the right direction please.

I am about to develop a website (using Dreamweaver CS4) which will contain training material. I have created a relational database (SQL) which contains all of the text in a very methodical, structured form. The core Tables are as follows:

Topics > Lessons > SubSections > Pages > Text

I also have a Media Table which defines images, Flash elements etc. This Table associates media through a Joining Table to Pages (a Page can contain many Media elements and each Media element can reside in many Pages).

Somehow I need to now create the website pulling in the Text and paths to the Media from the database. From my initial research on PHP I can see how I can simply call, for example, a SELECT statement and display a returned value, however I want to tie my Text to each page. In other words I want to create a new web page from a Template, which I will create, and then dynamically bring in the Text from the database associated with that page (using a page number assigned to the web page I guess).

I would be very grateful for any guidance or advice.

Regards

Chris

[coldwerturkey]

one of the hundreds of ways to do this, where your url looks like ?page=page_name_here:

//above content html

if ($_GET['page'] == 'home' || !isset($_GET['page'])) {
  //query home page content
}

elseif ($_GET['page'] == 'about') {
  //query about page content
}

//below content html

I don't recommend using what I posted.. I'd never use it.. but hopefully that gives you an idea to some logic you can use.