calling a function within a function

[chops]

I have seen the code for this before on here and it worked so I don't know why this isn't. I am using a require to bring in a db function:
function connectDB(){
$user="";
$host="";
$pass="";
$db_name="";
$connect_db = @mysql_connect($host,$user,$pass);
return $connect_db;
};

and then I call the connectDB() function from within this function:
function getUsersArray(){
if (!$connect_db) {
echo("Database reported an error. Please try again.<BR>");
} else {
// Connect and get username array
mysql_select_db ($db_name);
$query = mysql_query("SELECT username FROM users");
while ($row = mysql_fetch_assoc ($query)) {
echo "<OPTION VALUE=\"" . $row["username"] . "\">" . $row["username"] . "</OPTION>";
};
mysql_free_result ($query);
mysql_close($connect_db);
};
};

...this doesn't work for some reason.

Anyone have a clue?

[ame12]

Can't tell, how are you calling connectDB(), the call to it isn't included in your lower function.

If you're having problems with the returned value try calling by reference:

function connectDB(&$cdb) {
...
$cdb = ...;
return ($cdb);
}

and calling it like this

$cdb = 0;
connectDB(&$cdb);

RW

===========================================
http://badblue.com
Free small footprint web server for Windows

File sharing, PHP, Access/Excel transcoding

[chops]

I missed a big part of the lower function, I call it just before my if:
$connect_db = connectDB();