Function help!

[katarra]

Okay, I'm getting this error:

 

Fatal error: Call to a member function recordcount() on a non-object in /home/katarra/public_html/functions.php on line 20

 

Thanks for any help!

 

Code:

 

<?php
/*************************************/
/*           ezRPG script            */
/*         Modded by JR              */
/*************************************/

//Function to check if user is logged in, and if so, return user data as an object
include ('config.php');
require ('adodb/adodb.inc.php'); 
$db = ADONewConnection($database); 
$db->debug = true; 
$db->Connect($host, $user, $password, $database); 

function check_user($secret_key, &$db)
{
		$query = $db->execute("select * from `players` where `id`=?", array($_SESSION['userid']));
		$userarray = $query->fetchrow();
		}

		if ($query->recordcount() == 0)
		{
			session_unset();
			session_destroy();
			exit;
		}
		foreach($userarray as $key=>$value)
		{
			$user->$key = $value;
		}
		return $user;
?>

[Alex]

$query isn't an object so it doesn't have any members, thus you can't use the method fetchrow() on it.

[DarkendSoul]

Actually a quick search on the documentation says that it should be ->Execute with a capital E.

 

http://phplens.com/lens/adodb/docs-adodb.htm#ex2