Connect Function

fnbcprog

Why does this not work?

	function connect_db($db){

require("db_config.php");
$link = @mysql_connect($host, $user, $password);
if(! $link){
	echo"Unable to connect to the database server. Please try later";
	exit();
}      
if(! @mysql_select_db ($db)){
	echo"Unable to locate database. Please try again later";		
	exit();
}
}

<?
	connect_db("nbmm");
	$sql = "SELECT user from users";
	$result = mysql_query($sql);
	$num_rows = mysql_num_rows($result);

for ($x=1;$x<=$num_rows;$x++) {
	$row = mysql_fetch_array($result);
	print $row[user];
}
?>

</BODY>
</HTML>

nnichols

When you try to access the $host, $user, $password vars inside your function they are out of scope. You must set them as globals in order to access them, even though your "require()" statement is inside the function -

function connect_db($db){
global $host, $user, $password;
    require("db_config.php");
    $link = @mysql_connect($host, $user, $password);
    if(! $link){
        echo"Unable to connect to the database server. Please try later";
        exit();
    }      

    if(! @mysql_select_db ($db)){
        echo"Unable to locate database. Please try again later";        

        exit();
    }
}

Hoe this helps 😉