[Resolved] How to display specific Mysql data

j_yasa

Hey Everybody,

I am building dynamic website right now, I need help how to display specific data from mysql database to the web page.

Here is the scenario:
I would like to create webpage where all the content is stored into database.
I am using Dreamweaver MX to create the page template.
** For instance when I am on "Home Page" , the php script will call data from database and display the content on the "Home Page".

My questions are:
How should I structure the table. (e.g ID, page_name, Page_content, etc...)
How to query to mysql , so only select specific page_name, page_content will display on the page.

I try to search the forum but I cannot find the topics I needs. If you know this already exists on the forum please let me know (provide the links, please. Or tell me the topics name.)

Thanks

j_yasa

tomhath

What do you mean by "template" and "content"? If you want to store the HTML in the database it's possible, but that's not what I would consider dynamic content.

What is it you want from a database that you can't get from the file system?

j_yasa

Hey Tomhath,

I am Balinese, my english may notbe correct. Dynamic content maybe not the right word for it. What I am trying to do is build website with the capability for the administrator (client) to update the content of the pages. I want them to independently update the content in the database.

"Content" is text on the page that need tobe updated.

I am using Dreamweaver MX to create the page template. "Template" mean to me the web design (icon,banner, navigation, etc) that will not change nor be stored in database.
I will create administrator interface to update database (Content Management System).

I hope that make sense.

Thanks,

j_yasa

tomhath

The only problem I see with it is that the content in the database is based on how the pages are displayed. If you ever want to keep the same content but change the layout of your site it would be hard to reuse what is in the database. If that is not a problem then the design you suggested in your first post should work.
I don't use Dreamweaver much, but there are plenty of articles on using it with MySql if you search on Google. Here's a page that looks like a good place to start:

http://www.macromedia.com/devnet/mx/dreamweaver/php.html

j_yasa

Hey,

Thank you so much........ I find the solution. Macromedia link above is the ultimate answer.

Thank again.

j_yasa