You can't have a database driven site using basic HTML you'll have to use a server side language such as ASP.

edit - Just noticed you mentioned PHP (server-side language) and yes it works very well with mySQL.