[RESOLVED] MySQL inside a function

[slightlyeskew]

Hey all!

Is there any reason I wouldn't be able to put a call to my database inside function? E.g.

//assume proper db connection
function summary_report()
{
$A = $db->query("SELECT Certificate_Number FROM StockCertificates WHERE ShareholderID = $currentID ORDER BY Certificate_Creation_Date DESC");
}

When I run (albeit a slightly more complicated) script with this in it I get this error:
Fatal error: Call to a member function query() on a non-object in ... on line 28.

I haven't seen this error before so I thought it might have something to do with the call to the database inside the function. Thanks for your help!

[halojoy]

Inside function $db object has no value.
You can solve this by making it global.
A global variable value exists both outside and inside function.

//assume proper db connection
function summary_report()
{
global $db;

$A = $db->query("SELECT Certificate_Number FROM StockCertificates WHERE ShareholderID = $currentID ORDER BY Certificate_Creation_Date DESC");
}

[Neville1985]

Adding onto what joy said, here are a few more ways.
1/ Set and unset the object within the function itself

function summary_report() 
{ 
//set
$db = new databaseObject; //Change the object name
$A = $db->query("SELECT Certificate_Number FROM StockCertificates WHERE ShareholderID = $currentID ORDER BY Certificate_Creation_Date DESC");
//unset
unset($db);
} 

2/ Set it like you currently have and give the function the object during the function call. (looks a little more complicated, but its not.)

$db = new databaseObject; //Change the object name
function summary_report($db_object) 
{ 
$A = $db_object->query("SELECT Certificate_Number FROM StockCertificates WHERE ShareholderID = $currentID ORDER BY Certificate_Creation_Date DESC"); 
}
//then call the function like this
summary_report($db);

Hope this helps

[slightlyeskew]

Thanks guys!