php mysql regex

[andyd34]

I am constantly getting the following error

 

Fatal error: Call to a member function sql_query() on a non-object

 

I am using this function

 

function pcode_search($code) {
if(isset($code)) {
$sql = "SELECT user_id 
				FROM phpbb_users 
				WHERE user_pcode regexp '^" . $code . "[0-9]+' = 1";

$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
	$result_users[] = $row[0];
}
$db->sql_freeresult($result);
	if(isset($result_users)) {
		return $result_users;
	}
	else
	{
		return false;
	}
}
}

 

I just cant get my head round it and could do with a second opinion

 

Thanks

[Bricktop]

Hi andyd34,

 

Have you defined $db somewhere, either as a global variable or similar?

[andyd34]

Thanks for that, it helped more than you would know. I have added my own functions page to phpbb and am having trouble getting my head around there coding

[andyd34]

http://www.phpfreaks.com/forums/index.php/topic,118755.0.html