how can i connect a form on either dreamweaver or frontpage to a mysql database or is there any other ways of doing it.
also i would like to know the benefits of phpmyadmin in respect to php source code generation and how it works

All you need to do is to get mysql running on your local machine , then you would have to goto php my admin set your database parameters . Now goto dream weaver on the right hand side you would see application click on it under it you would see database . Read dreamweaver help file for more. I hope this helps you.

My Brother, i will like to advice you.

For you to be the master of you PHP code learn to write it from the source code, the Dreamweaver Server Behaviour is not a solution.

if you can understand the code here a typical PHP connection string to MySQL db.

<?php

define ('DB_USER', 'type_username_here');
define ('DB_PASSWORD', 'type_password_here''');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'type_database_here');

$conn = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die('Failure: ' . mysql_error() );
mysql_select_db(DB_NAME) or die ('Could not select database: ' . mysql_error() );

?>

thats all.

and for phpMyAdmin, this solution is a web base MySQL Admin tool, and it is very important also.

Cantact me for more help
info@bengallery.net
08037490533

To connect a form to mysql database through dreamweaver folloe this process very well and at the end i am sure you have you problem solved:

step1::develop you database in mysql command interface using sql syntax or design it through phpmyadmin(i'll explain later)

step2::after the development or designing the database, open your webpage in dreamweaver to connect the database to the form
NOTE:: THE NAME OF TH FORM ON THE WEBPAGE COS IT WILL BE MADE USE OF LATER

step 3:: At the top rigth hand corner of your DW tool after the webpage must have been opened
Click on database and a sublink will open "mysql connection" then click on it
step4:: A dialog page will open
STEP 5:: I'LL CONTINUE IF YOU GET IT SO FOLLOW THIS STEP
AND IF ARE ABLE TO GET TO THIS DIALOGUE BOX THEN WE CONTINUE ELSE I,LL START ALL OVER
SO LET ME SEE YOUR RESPONSES

Let me second benGallery and also say you need a good grip on the php language so as to do common task like mysql database or any other database for that matter. In anycase here is a much more simpler connection script

<?php
$hostname = "localhost";
$database = "yourdatabasename";
$username = "root";
$password = "yourpassword";
$conn = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db('yourdatabasename');
?>

just paste this at the start of the source code page and be sure to substistute "yourdatabasename" and "yourpassword" with their actual values