include file function erroring

ChelliSage

Hi,

I have a problem with a function inside an include file.

The include file:

<?php
$connection = mysql_connect("localhost", "testmanager", "testmgr") or die
("Unable to connect!");

function getstat($statno) {

$statquery="select StatusDescr from tblTestingStatus where StatusNo=$statno";
$res=mysql_db_query("TestManagement",$statquery,$connection)
or die (mysql_error());
$data=$mysql_fetch_array($stat);
$var=$data[StatusDescr];
echo "$var";
}
?>

From another file I call the function:
getstat($statno)

If I put the contents of the function directly into the file that calls the function it works, with no problems. However, if I call the function I get the following error:

Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /usr0/html/testmanager/reports/functions.inc.php on line 8

Any help would be appreciated.

bad76

$res=mysql_db_query("TestManagement",$statquery,$connection)
or die (mysql_error());

$data=$mysql_fetch_array($stat);

What is $stat ? where you get it ?

ChelliSage

I'm sorry, bad copy and paste job, I've been trying several things.

The line actually reads:
$data=$mysql_fetch_array($res);

Thanks

bad76

Well,
if you say that this line on your file is right, the problem may be the variable scope: $connection must be global.

But i can't understand why don't die before fetch array...

ChelliSage

That worked!
I changed the call to:
getstat($stat,$connection);

which passed the previous connection into the called function and then added $connection to the function declaration:
function getstat($stat,$connection) {

and everything works peachy now! YAY😃

I will try to figure out how to mark this as resolved.

Ben You ROCK!