Running XP Pro... Using mySQL/PHP and running both Dreamweaver and Frontpage. Trying to figure out what is the best program to use and the best way to connect to mySQL...Any help would be greatly appreciated...

I'm running XP Pro and I have both Dreamweaver and Frontpage 2003, too. And I tell you Dreamweaver is much better than Frontpage, especially the version I have(MX). When you're saying which is the best way to connect with MySQL, what do you mean? The best code to do so or how to put the code togother to be easier to read(and so easier to find errors).

The code I use to do so is:

<? /php open tag
$conn = mysql_connect("somehost", "username", "somepass"); /function to connect to MySQL
mysql_select_db("somedatabase", $conn); /function to select database from MySQL
$sql = "CREATE TABLE testTable (id int not null primary key auto_increment, testField varchar(100))"; /construction of the command of MySQL
$sql_res = mysql_query($sql, $conn); /execution of the command
?> /php end tag

Now, as for how to put the code together:

It's good to create your own functions. For example, create one function that connects to MySQL and selects one database. Here's an example:

<?
function doDB() /function that connects to MySQL and selects a database
{
global $conn;
$conn = mysql_connect("somehost", "username", "somepass");/connection to MySQL
mysql_select_db("somedatabase", $conn); /selection of a database
}

function CreateTable($tablename) /function that creates a table in a database with the name given from the user
{
global $sql_res;
$sql = "CREATE TABLE $tablename (id int not null primary key auto_increment, testField varchar(100))";
$sql_res = mysql_query($sql, $conn);
}

/calling of the functions
doDB();
CreateTable("testTable");
?>

However, there a lot to learn about MySQL and PHP. Here's a book that helped me A LOT:

Teach Yourself PHP, MySQL and Apache, All In One - Julie C. Meloni (A really good book)

Also, I have two other books in PDF and some other tutorials - Give me your email to send you that information.

Hope I Helped!!!!:D