Creating a page for each database record

[Vestax321]

Firstly, I realize my question is pretty involved so pointing me in the direction of a good site / book which explains it will do just as good as an answer.  I would like know how to create a page in Dreamweaver for each record on a database much like you would see in product listing or account information.  I would strongly prefer to use SQL for the database.

[bregent]

You quesiton is really the basis of most dynamic web sites. Which server side scripting languages are you considering? David Powers has several good books on php/MySQL.

The basic concept is that you create a single dynamic page and pull the product details from the database based on criteria submitted. So you aren't really creating a page for each record.

>I would strongly prefer to use SQL for the database.

SQL as opposed to what? Most DBMS's are SQL databases.

[Vestax321]

Sorry im fairly new to Dreamweaver.  Which books by him would you suggest?

[David_Powers]

Buy them all.

You can find details of my books on my website: http://foundationphp.com/. The most appropriate one for Dreamweaver is "The Essential Guide to Dreamweaver CS4 with CSS, Ajax, and PHP". Approximately 500 pages are devoted to working with PHP in DW. Whether they answer your questions is a different matter.