Fatal error: Call to a member function fetchrow()

[seany123]

Fatal error: Call to a member function fetchrow() on a non-object on line 30

 

The strange thing is that this didnt happen before i moved to localhost...

 

anyway here is the code...

 

$query0 = $db->execute("select * from `spylog` where `player_id`=? order by `time` desc limit 20", array($player->id));
while($spy = $query0->fetchrow())
{

 

thanks

[Andy-H]

Are you using PDO?

$stmt = $db->prepare("select * from `spylog` where `player_id`=? order by `time` desc limit 20");
$stmt->execute(array($player->id));

while($spy = $stmt->fetch(PDO::FETCH_NUM))
{

[seany123]

Are you using PDO?

$stmt = $db->prepare("select * from `spylog` where `player_id`=? order by `time` desc limit 20");
$stmt->execute(array($player->id));

while($spy = $stmt->fetch(PDO::FETCH_NUM))
{

 

whats PDO?

[Andy-H]

It stands for PHP Data Objects, basically it's an abstraction layer for PHP to communicate with your chosen query language.

 

I assume that since you dont know what it is, your not using it...

Basically it allows you to chane the query language used on your website without having to make drastic changes to your PHP code.

 

If you wish to look into it and perhaps learn how to use it it';s in the manual.

 

PDO

 

I first saw it used in Rasmus Lerdorfs toys page in his post about using Oauth to post to twitter.

 

http://toys.lerdorf.com/archives/50-Using-pecloauth-to-post-to-Twitter.html#extended

[seany123]

It stands for PHP Data Objects, basically it's an abstraction layer for PHP to communicate with your chosen query language.

 

I assume that since you dont know what it is, your not using it...

Basically it allows you to chane the query language used on your website without having to make drastic changes to your PHP code.

 

If you wish to look into it and perhaps learn how to use it it';s in the manual.

 

PDO

 

I first saw it used in Rasmus Lerdorfs toys page in his post about using Oauth to post to twitter.

 

http://toys.lerdorf.com/archives/50-Using-pecloauth-to-post-to-Twitter.html#extended

 

i dont need that for the above to work surely.

[Andy-H]

No, ofcourse not but showing the code for your database class would help alot...

[Philip]

Either your query is failing, or your DB class isn't returning an object into $query0