Database connection failing (dreamwever Mx)

jimwoolfe

Please can anyone help ?
I,m trying to create my first dynamic site using Dreamwever MX / php mssql

I'm getting the following error message on I try to publish a page.
Fatal error: Failed opening required 'Connections/itsaplaything.php' (include_path='.:/usr/local/lib/php') in /homepages/9/d85934527/htdocs/phpindex.php on line 1

I've created and tested a database connection though Dreamwever and I've been able to run php test scrips but when
I try to publish a page containing a recordset I get the error
The server is running php 4.23

Thanks
JW

Kudose

I would get an FTP client like WS_FTP or CuteFTP and not do the dreamweaver thing. Dreamweaver is good for codig and the such, but I have had bad experiances with the FTP portion of the software. You should have this file and call it dbinfo.inc.php

<?
mysql_connect('localhost', 'username', 'password', 'dbname');
?>

Then on all the pages you need to connect to the DB for type this in above the line you run your queries

<?
include('dbinfo.inc.php');
?>

Hope that helps

jimwoolfe

Hi Kudose

Thanks for your reply. Just to make sure. Is Itall right to build/code the pages in dreamweaver but use ftp to upload

Kudose

Yes. You are correct.

jimwoolfe

Kudose

thanks for your reply.
Thought you may be interested to know I also posted this question on the dreamwever forum. I was told to upload a folder called connections which dweaver creates this when you define your data base connection. I did this and all works o.k. (and theres me thinking dweaver does everything!)

once again thanks for your time

jimw