How do I access Relational Databases using SQL?

Create or use a basic database table for this example. The following SQL script may be used to setup a contacts table:

https://www.hyfinity.net/wmforum/attachment.php?aid=41

Create a basic search page to trigger a SELECT request to the database to retrieve a list of contact records.

http://hyfinity.net/HowTo/database/contacts_list/contacts_list.htm

Provide the ability to select each of the records on the list and create a more detailed page that will display full details for the selected contact record.

http://hyfinity.net/HowTo/database/contact_details/contact_details.htm
Change the details for a selected contact and send an UPDATE request to the database.

http://hyfinity.net/HowTo/database/update_contact/update_contact.htm

Allow retrieval of multiple database records in a grid-like format with the ability to update details. Send multiple UPDATE requests to the database to confirm updates.

http://hyfinity.net/HowTo/database/edit_all_contacts/edit_all_contacts.htm

You can download a WebMaker export of the above examples from the following link:

http://hyfinity.net/HowTo/database/database_export.zip