--------------------------------------------------------------------------------

i am trying to connect a mysql database using phpmydmin and dreamwear mx. are there any good site people know of on how to do this also where do i get the connection details

Good day Ciaran,
Really briefly, I wanted to ask you where your mysql database is located. If you are referring to a mysql database on a server that you do not own (like a hosting provider's) then you might no be able to communicate with it remotely, depending on the provider's policies. Please note that most providers provide phpMyAdmin front ends for communication with their MySQL databases.

I am just taking a guess here but it appears that you are fairly new to mysql, dreamweaver and possibly php. So here is my suggestion.

Go to www.apachefriends.org/

There you will find an installer called Xammp that will run Apache and MySQL on your computer (windows or linux). Once installed or started (by the way the process is fairly straightforward) then you will be able to use phpMyAdmin and access MySQL through phpMyAdmin. After installation, just type localhost and it will take you where you need to be. It is much easier to work with the MySQL database through phpMyAdmin than Dreamweaver I would imagine. If there is something specific that you need guidance on, let me know, just try to be as specific as you can.

Thanks.

Oscar

if localhost then mysql connection is localhost or ipaddress of your machine.
If you have a hosting then go into your control panel create a new database and this should give you all the details that you need.
php code is
<pre id=code><font face=courier size=2 id=code>
$host = "your hostname";
$username = "username";
$password = "password";
$dbname = "your database name";
//mysql connection
mysql_connect($host, $username, $password)

mysql database selection
mysql_select_db($dbname);
</font id=code></pre id=code>