ADODB inside a function

[versatilewt]

php version: 4.3.10
adodb version: 4.8

I'm using ADODB to connect to my mySQL database.

the query is

$query="SELECT * FROM zipData WHERE zipcode='$_z'";
	$result = $db->GetAll($query);		// Execute queries
	$count = count($result);		// Count * rows   

whenever it is like

function functionname(){
$query="SELECT * FROM zipData WHERE zipcode='$_z'";
	$result = $db->GetAll($query);		// Execute queries
	$count = count($result);		// Count * rows 
}

the query fails, but if i take it out of the function, the error doesn't occur (Fatal error: Call to a member function on a non-object). the error occurs on

$result = $db->GetAll($query);		// Execute queries

Any ideas?

[esukf]

You are using some database wrapper class. $db should be an object. Make sure you have include the file with the class and create the object
ie $db = new Database;

[thorpe]

To put it simply, $db does not exist within the function.

[esukf]

looking at your post again changing the function to

function functionname(){
global $db;
$query="SELECT * FROM zipData WHERE zipcode='$_z'";
    $result = $db->GetAll($query);        // Execute queries
    $count = count($result);        // Count * rows
} 

might solve the problem depending where the function is located.