Member Function Error

ksstormhunter

Hello all, both a newbie at this and need help. I am trying to troubleshoot a php file that compiles fantasy stats. This is not my coding, I got this as an enhancement. I am getting an error on line 333. It says Call to a member function fields() on a non-object in. Any help or guidance would be greatly appreciated.

Here is the part of the file that it errors on The text in bold is where I get the error.

$players_ID=$rs->fields("ID");
             $total_value=0;
             $sql="select sum(fantasy_value) as total_value from players_statistics_fantasy where players_ID='$players_ID' and leagues_ID=$LEAGUEID and year_ID=$year;";
             $fantasy_rs=$DB->Execute($sql);
           [B]  $total_value=$fantasy_rs->fields("total_value");[/B]
             $players_array[$players_ID]=$total_value;
             $rs->MoveNext();

Weedpacket

It means [font=monospace]$DB->Execute($sql)[/font] didn't return an object. Can't say much more than that without knowing how that method is supposed to work and what it's supposed to return (is it guaranteed to return an object even if the query found no matching records?), and if the object has any error-handling methods in case, for example, the query it was given to execute was invalid.

ksstormhunter

Would attaching the entire php code help determine the cause better.

NogDog

This might possibly output some useful debug info:

             $sql="select sum(fantasy_value) as total_value from players_statistics_fantasy where players_ID='$players_ID' and leagues_ID=$LEAGUEID and year_ID=$year;";
             $fantasy_rs=$DB->Execute($sql);
// new code here:
             if($fantasy_rs == false) {
                 die("<pre>DEBUG:\n$sql\n".print_r($DB, 1)."</pre>");
             }