no connection to db file inn mySQL (WAMPP)
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?
