setting up mysql in dreamweaver

my ISP has set up mysql database for me, as I am totally new to databases. I'm working in dreamweaver which is also new to me, oh I can hear all your groans already. I've +Document Type:PHP. Mysql connection dialog box opened. Added server, user name, password, database - all this info was given to me by ISP. I don't know what is meant to be entered in the 'connection name' field. I added 'wholesaleprice' which is what i have named my php file, but received a message 'an unidentified error has occured' What do I need to enter in the Connection name.
thanks for your help

Lorraine

In that connection name field try putting something like $conn or just conn

They probably just want a php variable that they can assign the connection string too

Hi, I'm new to MySQL (and building websites). I'm working in dreamweaver 8 on mac osx. My ISP has set up MySql/PHPadmin for me in my cpanel. I've set up a testing server on my website.
Server Model: PHP MySQL
Access: Local/Network
Testing Server Folder: Showing the location of the folder I set up which holds serverscripts folder, mysql.php and php document files.
URL Prefix is showing as http:/MacintoshHD/_mmServerScripts/MMHTTPDB.php

The checklist in the 'databases' are all ticked.

Click + in Databases, select MySQL connection. Dialogue box appears.
Connection Name: - What should go in here, I have tried php document name, connection folder name and everything else under the sun. My ISP sent me the details for server/user/password and d/base, so I know they are correct. I click 'test' and receive this generated message.

HTTP Error Code 404 File Not found. Here are some possible reasons for the problem:

1) There is no testing server running on the server machine.
2) The testing server specified for this site does not map to the http://MacintoshHD/_mmServerScripts/MMHTTPDB.php?
Type=MYSQL&ConnectionString=host=remotemysqlhost;u id=glasall0_midph;pwd=******;&Host=remotemysqlhost &&Database=&UserName=glasall0_midph&Password=***** *&Timeout=30 URL. Verify that the URL Prefix maps to the root of the site.

As my ISP supports php/mysql and runs off Apache I'm sure I don't require any other applications, and I presume I don't need to set up a remote folder?

I have googled and googled, read and read, but cannot find an answer. I need help, 3 days I've been staring at dreamweaver! Please use beginner terms, I'm very green but very determined!

Thank you,
Lorraine

You already had a thread created in the PHP forum so I merged both and moved it here in the MySQL section.

Sorry about that Karinne, I think my head's about to explode. The suggestion you gave me earlier for the connection name didn't work unfortunately.

Thanks
Lorraine

I'm curious ... why I you using DW to set this up? Why don't you just put the code in the PHP file an away you go? This looks like a PITA to do for such a simple task?!

Karinne, I had to step back from this for a while, but in doing so I thought of what you asked, why am I doing this the difficult way. I couldn't agree more, and received some info on how to connect bypassing Dreamweaver's set up, and finally I am connected. Now to go and learn how to code in PHP :-) and build a database. Off to do some reading here.

yo,
im sorry i'm confused. i have exactly the same problem with setting up my database in Dream Weaver. I need to use DW cause i'm making my website on DW. I've downloaded MySQL, set it up, and now i'm trying to set up this MySQL connection in DW...but this error message comes up when i press "test"..

Http Error Code 404 File NOt Found. Here are some possible reasons for the problem:
1) There is no testing server running on the server machine.
2) The testing server specified for this site does not map to the http://geocities.com/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site.

what on earth do I do? i'm using geocities to host the site online - is this a problem? i haven't done much on the making of my website, so i can start from scratch!
also im asked during the dynamic data setup in DW -

Dreamweaver communicates with your testing server using HTTP, so it needs to know the URL of your site's root folder.
What URL would you use to browse to the root of your site?

It has accepted my answer, but i can't help but wonder this is where the problem lies? i just don't know how to uncover it! ek!

additional...do i have to install php? may be a stupid question, but does definately have to be asked!!

thank you for your time in advance!
rob

Hi Frank. Unfortunately, this is why WYSIWYG editors are the devil! I have a few questions that you'll need to answer before anyone can help you.

1. Do you have a web server locally on your computer..such as Apache, IIS? (Geocities is not a testing server. A testing server is a server on your machine for debugging purposes before the site goes live)
2. Have you installed MySQL?
3. Yes, you have to install PHP.

After all that, you need to learn how set up a database in MySQL and use PHP syntax to access it. If you haven't done any of these things, here's some reading for ya.

• Apache Web Server
• PHP
• MySQL

I hope this steers you in the right direction. i can be quite overwhelming at first.

Good Luck and let us know how your coming along,
Scott

__________________
Web Design and Development

If you want all three and an easy way to install http://www.apachefriends.org/en/xampp.html

easy, clean and great help all along the way....it is how I started to learn sql....