Database Queries in Safe mode on and Globals off

[amdav]

I am fairly new at this, and I am creating an ecommerce site for someone. I contacted the ISP and they said they were running with Safe mode on and Globals off. I was wondering if someone can tell me if this should affect my database queries or not, as I have been having trouble getting my queries to display results.

Thankyou so much for any help.

[goldbug]

Possibly. Kind of depends on your code.

[amdav]

Thanks for your reply,

I am trying to access it with the following code:

<?php
$host= "host";
$user= "user";
$password= "password";

$dbName="Products.mdb";
$tblName="Products";

$link= mysql_connect ($host, $user, $password);

$query = "SELECT * from $tblName";

$result = mysql_query ($dbName, $query, $link);

print ("<TABLE BORDER=1 WIDTH=\"75%\" ALIGN=CENTER>\n");
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>PART NUMBER</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>PART DESCRIPTION</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>QUANTITY AVAILABLE</TD>\n");

while ($row = mysql_fetch_array ($result)){

print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$row[Part_num]</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$row[Descr]</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$row[Qty]</TD>\n");
print ("</TR>\n");
}
mysql_close($link);
print ("</TABLE>\n");
?>

is there a different coding I need to use ?

[Sxooter]

Nope, that code should work as well with globals off as on, and the same is true for safe mode.

However, unless the latest versions of mysql_query have changed, you aren't doing it right. You need to use mysql_select_db() first.

[amdav]

Thanks,

I tried putting in the following function and got an error back saying " Error in selecting Products.mdb database ", would this mean I am not connecting to the database?

(This is the code I used):

$link= mysql_connect ($host, $user, $password);

function SelectDB($dbName)
{
$retVal = 0;

	// Select the $dbName database
	$retVal = mysql_select_db($dbName);

	if(! $retVal)
	{
		printError( sprintf("Error in selecting %s database", $dbName) );
	}
	else
	{
		printf("Selected database %s\n", $dbName);
	}

	return($retVal);

}// end: SelectDB()

function printError($errorMsg)
{
	printf("%s\n", $errorMsg);
}// end: printError

SelectDB($dbName);

Thanks for any input you can give me.

[goldbug]

Your database is actually called 'Products.mdb'? You're not trying to use a file created by MS Access are you??

Also see:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Legal_names
specifically the part on database names, allowed characters ("." is NOT allowed)

[amdav]

yes, why is this bad?

[goldbug]

well.... it's kind of silly to use MySQL functions on an Access database. They're sort of intended for an actual MySQL database. You might want to try ODBC functions. Check out the PHP manual for ODBC stuff.

[Sxooter]

Yeah, you really need to export your file from the mdb file to some kind of tabbed or csv file and import it into mysql (or postgresql if you've got it) and then access it.

MySQL can't really access .mdb files can it?