Variable inside mysql_connect() fails, why?

[tottis]

Hi.

I have searched for a solution for this problem, but unfortunatly not found any.

When I write my mysql_connect() function like this, it works:

mysql_connect('localhost', 'username', 'password')

But if I put variables inside the function i fails. Ex:

$SESS_DBUSER = 'username';
$SESS_DBPASS = 'password';

function db_connect()
{
$result = @mysql_connect('localhost', $SESS_DBUSER, $SESS_DBPASS)

if (!$result)
	return false;
if (!@mysql_select_db(userdb))
	return false;
return $result;
}

Does anyone know why or could post an url with more information about this problem?

[Roger_Ramjet]

Becaus you declare them outside the function so they are outside it's scope.

[Roger_Ramjet]

Becaus you declare them outside the function so they are outside it's scope.

You will have to pull them in using global

$SESS_DBUSER = 'username';
$SESS_DBPASS = 'password';

function db_connect()  {
   global $SESS_DBUSER, $SESS_DBPASS;
   $result = @mysql_connect('localhost', $SESS_DBUSER, $SESS_DBPASS)

if (!$result)
    return false;
if (!@mysql_select_db(userdb))
    return false;
return $result;
}