PHP/MYSQL/Apache troubles!!! Help!

[Hung Kuen Kung Fu]

I have been trying for a while to get a database connection through Dreamweaver
using mysql. I always get an unknown error. I am running MySql 4.1. I can
access it and write to it successfully. It is running in windows services. I
am running Win XP Home so I Installed Apache 2. The Apache 2 resides in the
following path on my computer C:\Program Files\Apache Group\Apache2\ There is
no wwwroot folder or warehouse folder as dreamweaver help suggests. It
indicates that apache services are running. Now when I set up my site I am not
sure where the local root folder should be. Also I am not sure of the remote
folder should be for local/network access. I am using the testing server
PHP/MYSQL model but am unsure where the testing server folder should be
(C:\Program Files\Apache Group\Apache2\ ?) I am unsure also what to put into
the prefix spot. I am assuming I am doing this part all wrong and that is why
I can't connect to my database. Any and all suggestions are appreciated. I am
new at this so I am really unsure as to what I am flubbing at. Darren:confused;

[David Powers]

Hung Kuen Kung Fu wrote:

> There is
> no wwwroot folder or warehouse folder as dreamweaver help suggests.

The default location for your server root on Apache2 with Windows is

C:\Program Files\Apache Group\Apache2\htdocs

You can change it to a more convenient location by making a couple of
changes to httpd.conf, but that is where it lives normally.

> i am not sure where the local root folder should be.

In the htdocs folder just mentioned.

> Also I am not sure of the remote
> folder should be for local/network access.

The remote folder has nothing to do with local/network access. It's
where you eventually upload your files to your hosting company.

> I am using the testing server
> PHP/MYSQL model but am unsure where the testing server folder should be

All your files/sites should be in htdocs or a sub-folder of htdocs.

> I am unsure also what to put into
> the prefix spot.

If your site is in the following location:

C:\Program Files\Apache Group\Apache2\htdocs\mynewsite

the URL prefix will be:

[url]http://localhost/mynewsite/[/url]

Don't omit the trailing slash after the site folder name.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]