PDA

View Full Version : no connection to db file inn mySQL (WAMPP)


chasmichaelp422603
04-07-2011, 02:29 PM
I am using XAMPP while following the training-instructions set forth in the “Database_Starter_Kit_PHP” flash video training series. Unfortunately this training program uses mySQL in some kind of stand alone mode that uses a different GUI than XAMPP, nevertheless, I think I imported the “physical_goods.sql” db correctly and as I followed all the steps in DW it didn’t burp or belch. HOWEVER, when it came to step 09 Previewing your data, the following messages appeared in both the browser and in Live View:

Warning: virtual() [function.virtual]: Unable to include '/htdocs/WebAssist_Dynamic/ConnWA.php' - request execution failed in C:\xampp\htdocs\recordset.php on line 1

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\xampp\htdocs\recordset.php on line 34

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\xampp\htdocs\recordset.php on line 36

Line 1 <?php virtual('/htdocs/WebAssist_Dynamic/ConnWA.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {

}

Line 34 mysql_select_db($database_connWA, $connWA);
$query_rsItems = "SELECT ItemName, ItemLongDesc, ItemPrice, ItemThumb, items.ItemCatID FROM items WHERE ItemPrice < 50 AND items.ItemCatID =1 ORDER BY ItemName ASC";
Line 35 $rsItems = mysql_query($query_rsItems, $connWA) or die(mysql_error());
$row_rsItems = mysql_fetch_assoc($rsItems);
Line 37 $totalRows_rsItems = mysql_num_rows($rsItems);
?>

In addition, in the testing server file view all the files are red (pink) but the files in these folders are green. Both the files and folders are green in local view. In reality I am doing everything on the testing server. I did not build a local_site directory to avoid unnecessary duplication ( an approach recommended in WAMPP instructions.

Any ideas?

Jason Byrnes
04-07-2011, 03:44 PM
In your Dreamweaver site settings, there is an option on the Local Info tab to to "Create Links relative To", set this to Document instead of site so that Dreamweaver will use the require_once() function for include files instead of the virtual() function.