Hello this is my first post on these forums and im looking for some help if all you pro-designer/developers out there wouldn't mind helping me out.

For years now I've been tinkering with web designing, but have never produced a website because of various reasons. Eventualy I just kinda' made header Graphics and Logos in fireworks and gave up on my dreams of producing awsome websites. Anyways this time round the gloves are off I'm determind to make a high quality proffesional web site so I started reading.

 

My first thoughts are to start out making a blog, and luckily enough I found a tutorial in a book(Dreamweaver The Essential Manual Edited by Andy Stewart.) I own which had been gathering dust for some time. Long story short I set up a server on my machine install PHP and MySQL and configure the wwwdirectory (Lies, All Lies!!! WAMP5 did it all.)

So now im cooking I have a server on my computer, well the tutorial said to access PHPmyAdmin and create a database. After a few clicks of WAMP5 icon menu in the systems tray I was off on my magical adventure of PHP, MySQL and other magical exotic far out terms and doodads that I could never be botherd to learn about at collage, pff html/CSS and Macromedia FTW...

Enought with all that I'll go through the first few steps on what the tutorial tells me to do up to the part where im stuck.

 

1. Set up database

create Blog as a database. (done)

 

2.Create two tables

one named Entries and one names Users.(done)

 

3. Create a User (done)

 

Then after these steps I am instructed to close the browser and open up Dreamweaver, define a new site, enter remote server info and testing srever info.

Hit 'Done' and creat a new php page called Sign-in.php.so i did that no problems, but here where it all goes wrong.

 

1.Define a connection in dreamweaver.

Applications panel > hit the '+' > select MySQL connection > enter my information (I was very careful with this i did not make any errors at all)

 

 

But When I hit 'Select' too the right of the database field i get this.

 

 

well the thimg is I've read the warning and I've tryed to correct it but I realy can't see the problem in any of the site definition settings.

 

 

My localhost root is C:/Documents and Settings/Family/My Documents/My sites.

 

Thank you in advance if you decided to help me i would be realy greatful, i just realy realy want to make a website ive been trying for years and somethings allways gotten in the way but its not anymore.

 

Edit:P.s when I go through that process afterward i find new folders inside my root folder

 

Folder 1:Connetions > Blog.php

Folder 2:_mmServerScripts > MMHTTPDB, mysql.php, _notes(sub_folder)

Hi Dispel,

 

I think I have the answer to your question.

Rather than spending hour writing how to setup your environment in Dreamweaver please follow the link to my site where I'm expalining how to do it: Defining Project in Dreamweaver.

 

This is tutorial which I have written on how to create Link Exchange System with Dreamweaver, PHP, MySQL and CSS.

 

Another tutorial which I have written and you may find useful is: Setup Apache, PHP and MySQL on Windows XP - In case you would decide to install all components seperately.

 

I hope you'll find it useful.

 

Take care,

Thanks alot I'm going to look through both tutorials now.

Hmm I'm following your tutorial, but after I create the SQL file and run the command in the commandprompt i get this reply

 

 

is there some setting im missing here ? When I installed Apache,PHP and MySQL i used WAMP5 and that basicaly did it all for me. Any suggestions you might have would be appreciated.

 

Edit1:Ahh ok in the systems tray if i click the WAMP5 icon in the i can launch a MySQL console that asks for a password if this the console u was trying to get me to access in your tutorial if so, can i carry on with the tutorial from there ?

 

Edit2: never mind im back on track thanks.

Ok so i know I have MySQL console running and I have a password on the root user I have the database made and saved to the server I just cant select it in the connections dialog box it says:-

"1) There is no testing server running on the server machine."

"2) The testing server specified for this site dose not map to the http://linksexchangesystem/_mmServerScripts/MMHTTPDB.php URL. verify that the URL prefix maps to the root of the site."

 

but I have configured all these settings correctly in the site definition dialog box in dreamweaver so I dont get it, I have the database's I have the server. Dreamweaver simply dosent want to connect to the database's.

 

P.s when I was installing WAMP5 it gave me the option to change the directory of my server so instead of it being C:/apache/htdocs.

its actualy

C:/Documents and settings/Family/My Documents/My Sites.

I created the my sites folder there and made this my wwwdirectory(I'm a mac user at heart and I prefer using a My Sites folder in my docs). So if this has anything to do with the issue which I doubt, as I substitue your path for my own. Then I'm completly at a loss.

Your root site must be in the 'htdocs' folder to work.

Make sure your server is running and enter this in the browser to test it:-

http://localhost

Don’t leave spaces in folder or page names i.e. My Sites (My_ Sites).

Then try this:-

http://localhost/My_Sites

 

good luck

cheers