$query problem

[chriswatson]

At the moment i have a code that looks like-

		$query='select id from users where username="'.$sessuser.'"';

	$q->query($query);

	$q->next_record();

	$userid=$q->f("id");

	$query='select COUNT(*) as numar from pending where (userid='.$userid.')and( frome like "%'.$searchemail.'%")';

	$q->query($query);

	$q->next_record();

	$numar=$q->f("numar");

I do not wish to use the $query anymore and would the above to work like-

$sql = select id from users where username="'.$sessuser.'"';

So i need to change all the $q & $query

But i'm not sure how to change it all. Any help please ?

Thanks
Chris.

[TheDefender]

$sql='select id from users where username="'.$sessuser.'"'; 

    $q->query($sql); 

    $q->next_record(); 

    $userid=$q->f("id"); 

    $sql='select COUNT(*) as numar from pending where (userid='.$userid.')and( frome like "%'.$searchemail.'%")'; 

    $q->query($sql); 

    $q->next_record(); 

    $numar=$q->f("numar");

Just change everything that reads $query to $sql. If this isn't what you meant, you need to post more details to better explain exactly what you are wanting to do.

[chriswatson]

The problem is when i run the above code i receive the following error-

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

Thanks
Chris.

[tsinka]

Hi,

seems like $q is not an object. Maybe you accidently removed the line that creates the object or something like that.

Thomas