Desperately need help with MySQL/Apache/PHP &Dreamweaver MX 2004

[Artspan]

:frown;
I probably have no business trying to do what I'm doing, but here's the
scenario: A client has hired me to create their e-commerce website using a
3rd-party shopping cart. As their prices change often, I thought it would be
best to enter the prices dynamically into Dreamweaver pages so that when a
price change occurs, one change in the database would make one sweeping change
wherever that item occurs on the site. So far, this makes sense, right?

So I decide PHP + MySQL makes the most sense, and I follow some tutorials to
create a database in MySQL, add a table and upload data into the table. That
worked well. Then I followed more tutorials to configure PHP with Apache2, and
after many attempts to put Apache and PHP into one folder (C:/www), discovered
that Apache2 doesn't start unless it's in C:/Program Files/Apache
Group/Apache2. So now I have two directories: C:/www/php and Apache2 in the
Program Files directory, with C:/Program Files/Apache Group/Apache2/htdocs the
root. First question: Should MySQL, PHP, and Apache share a common directory?

When I try to make a database connection in Dreamweaver, I enter the following
info in the fields:
Connection Name: aiomysql
MySQL Server: Either localhost of the DNS of localhost (127.0.0...)
Username: My username
Password: The password I used for MySQL
Database: I type in the name of the database

And I get error code 405: Method Not Allowed every time.

If anyone can detect what I'm doing wrong, please help!! I either have to
abandon this plan and tell the client we'll have to make manual changes, or get
this fixed and on the way!!

MANY THANKS!!
Carolyn

[Artspan]

Typo in the above: MySQL Server is either localhost OR the DNS...