Skip to Main Content
Dreamweaver CS5.5: The Missing Manual
book

Dreamweaver CS5.5: The Missing Manual

by David Sawyer McFarland
June 2011
Intermediate to advanced content levelIntermediate to advanced
1216 pages
45h 55m
English
O'Reilly Media, Inc.
Content preview from Dreamweaver CS5.5: The Missing Manual

Chapter 25. Adding Dynamic Data to Your Pages

A database is different from a mere pile of facts because it can selectively retrieve information. After all, when you visit Amazon.com, you don’t want to see every single book and product they sell. You probably just want to see a list of books on a certain subject or by a particular author, and then view more detail about the books that pique your interest.

This chapter shows you how to use Dreamweaver to display database information on your web pages. Because these concepts can be tricky, you may prefer to get some hands-on experience by completing the tutorial on Tutorial: Displaying Database Info before reading the rest of this chapter.

Retrieving Information

Since databases can contain lots of information, you need a way to find just the data you want to display on a particular web page. Even though your company keeps information about its products, customers, suppliers, and so on in one database, you may want to see only, say, an alphabetical list of your customers. After grabbing that list, you might want to display a particular customer’s contact information, or perhaps the list of products that person bought.

Understanding Recordsets

To retrieve specific information from a database, you start by creating what’s called a recordset. A recordset—also called a database query—is a command you send to a database asking for particular information: “Hey Database, show me all the customers listed in the Customers table.” Executing commands ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Dreamweaver CS6: The Missing Manual

Dreamweaver CS6: The Missing Manual

David Sawyer McFarland
Dreamweaver CC: The Missing Manual

Dreamweaver CC: The Missing Manual

Chris Grover, David Sawyer McFarland

Publisher Resources

ISBN: 9781449309541Supplemental ContentErrata Page