DB Function within a Function

[chops]

Does anyone see a problem with my function call of connectDB() in anotherFunction(). This will not work for some reason..

function connectDB(){
$user="";
$host="";
$pass="";
$db_name="";
$connect_db = @mysql_connect($host,$user,$pass);
return $connect_db;
};

function anotherFunction(){
$connect_db = connectDB();
if (!$connect_db) {
echo("Database reported an error.");
} else {
mysql_select_db ($db_name);
$query = mysql_query("SELECT whatever FROM whatever");
$result = mysql_result($query, 0);
return $result;
};
};

[jcornett]

What error message are you receiving (if any)? Take the @ off the connect string and see if it gives you an error then. Try the below code to see if you are connecting... you can always change it back to the original code once you find out where the error is. 🙂

$link_id = mysql_connect($host, $user, $pass)
or die($php_errormsg);

Also, why the semi-colons after the close brackets? 🙂

John Cornett

[chops]

John Cornett wrote:

What error message are you receiving (if any)? Take the @ off the connect string and see if it gives you an error then.

Also, why the semi-colons after the close brackets? 🙂

John Cornett

Well I am getting no error messages I am just not getting connected ....if I replace the connnectDB() with just:
$user="";
$host="";
$pass="";
$db_name="";
$connect_db = @mysql_connect($host,$user,$pass);

it works...as for the ; at the end of closing brackets....it's just a bad habit