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.
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.
I personally use Coda, by panic for my web programming. I also highly recommend it over Dreamweaver.