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

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>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<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Username & Password are for the database, not the MySQL server (root) or anything like that. Each database should have a user assigned to it, and use that users' login. Make sense?

Also, normally you would just use 'localhost' as the server, but if your database is on a seperate box (server) then you'd need an address.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>