Pear::DB issues

scrypte

here is the connection:

/*
Database Connection | Pear::DB API
--------------------------------------------------------------*/
$dsn = "mysql://$user:$pass@$host/$db_name";

$db = DB::connect($dsn);

if (DB::isError($db)) 
{
        die ($db->getMessage());
}

here is the code:

/**
 * Creates the header for the directory
 *
 * @param string $hostname
 * @param string $view
 * @param string $i
 * @return string
 */
 function top_nav($hostname,$view, $i) 
 {
 		$l = chr($i);

	// Connect to the database so that 
	$s = "SELECT * FROM md_models WHERE alias REGEXP '^($l)'";
	$q = $db->query($s);

	if (DB::isError($result)) 
	{
    	die ($result->getMessage());
	}

	$r = $q->fetchRow();		
	$v = $db->getOne($s);


	// Print valid letters
	if ($v!=0)
	{
		$letter = '<td  width=20 align=center>
		<a href="index.php?cmd=find&l='.$l.'&view='.$view.'" 
		style="color: black; text-decoration: none; font-weight: bold">'.$l.'</a>
		</td>';
	 }
	 else
	{
		$letter = '<td  width=20 align=center style="color: #CCCCCC; font-weight: bold">'.$l.'</td>';
	}

return $letter;

}

This is the error:
Fatal error: Call to a member function on a non-object in /data1/members.scoreland/docs/cgi/secured/modeldir/lib/functions/functions.misc_utilities.php on line 77

Here is line 77:

 		$q = $db->query($s);

Does anyone have any clue what is causing the issue, its starting to annoy me.

Installer

Your connection resource variable ($db) is in the global scope. You're trying to use it in the function scope. You can't do that; you need to pass the resource to the function. Maybe that's what $hostname is meant to be (although, if so, it's scarcely more descriptive than $q or $r or $s) since it's not used anywhere (but then again, it's described as a "string" in the comments...). What code do you use to call the function?

Variable Scope

Correction: It's an object in this case, not a resource. Otherwise, the same.