php mysql connection error

wxdqz

New Member
Hi All,

I have a conn.php page like this:
$username = "root";
$pwd = "";
$host = "localhost";
$dbname = "Gulfstream";

if (!($conn=mysql_connect($host, $username, $pwd))) {
printf("error connecting to DB by user = $username and pwd=$pwd");
exit;
}
$db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1");

then I have a prod.php which takes a variable in a querystring and tries to hit the DB where I get this:

Fatal error: Failed opening required 'dbconng' (include_path='') in C:\Inetpub\wwwroot\php\gulfstream\products.php on line 4

yet in the file, it looks like this:
require("commonmn.php");


//header logo
$msg1 = "";
HTMLHeader(); //function to print header
require("dbconng"); //is on line 9
$SQLProd = "select * from gulf_products where prod_name = $prod";

$SQLResult = mysql_query($SQLProd, $conn) or die ("Couldn't execute query1");
echo" <table width = 600 valign = top>";
//pass the info to the screen

Any ideas??

TIA

Bastien
$row = mysql_fetch_array($SQLProdGet);
 
Back
Top