What is a good application for designing a MySQL-driven website on Mac OS X?

I am developing a web site that allows users to search for information stored in a MySQL database on a Mac. I am looking for an application to assist in the design of the web site, allowing me to create search forms to retrieve the data from a MySQL database on a Mac OS X computer. I do not want to outsource this task or to have another company host it. Any suggestions and/or advice will be appreciated. Thanks.

Public Comments

1. Dreamweaver is an application that will allow you to write code for a website that can access a MySQL database. But you will need a server to host the website as well as the database.
2. I personally use Coda, by panic for my web programming. I also highly recommend it over Dreamweaver.