Getting started with MySql and PHP

[moss2076]

I want to have a go at creating a database in MySql and php. I have only ever built a database in MS Access before now and linked it to a webpage with ASP via Dreamweaver.

I have a few questions -

Is PHP only designed to run on a web browser like ASP?

If so, what is the best (free) software to create database tables, queries etc? Is it done inside Dreamweaver which I already have installed?

I need some help how to get started and would be very greatful for any advice.

[_Aerospace_Eng_]

No you don't create databases with dreamweaver. You need a webhost that supports php and mysql. Once you have that I recommend using phpmyadmin. Its a tool that allows you to manage your databases very easily. You can use php to pull information from the database. Dreamweaver would be okay for that. If you setup a site in Dreamweaver CS3 then you will be able to have the php generated for you with the click of a button.