Warning: Use of undefined constant

[Anon]

i recently upgraded mysql to the lastest version and now i get all these crazy messages on scripts that worked fine previously. btw, i use apache/mysql on WIN98.

i.e.
here's the basic script with database info:

<?
$db_link=mysql_connect("myhost","myusername","mypassword");
if(!mysql_select_db(data,$db_link))
{
print("There was an error connecting to the database.");
}
?>

when the script is called I get this message:

Warning: Use of undefined constant data - assumed 'data' in c:\program files\apache group\apache\htdocs\usr\local\data\dbinfo.php on line 3

any ideas on this? thanks in advance for any help.

[mattw]

if(!mysql_select_db(data,$db_link))

is your database named data? If so, it should be:

if(!mysql_select_db("data",$db_link))

otherwise you need to define a constant named data.

define("data", "dbname");

if you alot of places that it issues this warning and your dbname IS data, just define a constant at the top of the pages, that way you don't have to change each line individually.

define("data", "data");

The reason it probably used to work is that the warnings were suppresed. What happens if a constant is not defined is that it echos out the name of the constant and then sends a warning message. If warnings were suppressed, it would have just echoed out the constant name which happens to be the database name.

Hope that made sense, I'm going on very little sleep here..... 🙂

Matt Wade
codewalkers.com

[Anon]

yeah, that worked. thanks. the database was named data. i thought i tried using quotes but apparently i didn't. thanks again.