undefined function: query()

ganga_din

getting the following error message:

Fatal error: Call to undefined function: query() in /hsphere/local/home/gangadin/awarra.com/lib/classes/class.news.php on line 253

Code causing error:

function getNewsTypes() {

    $sql = "SELECT
                news_type_id,
                news_type
            FROM
                ".PREFIX."_news_types";

    if (DB::isError($rsTmp = $this->_oConn->query($sql))) {

        catchExc($rsTmp->getMessage());
        return false;
    }

    // build return array
    $i = 0;
    while ($aRow = $rsTmp->fetchRow(DB_FETCHMODE_ASSOC)) {

        $return[$i]["News Type Id"] = $aRow["news_type_id"];
        $return[$i]["News Type"] = $aRow["news_type"];
        ++$i;
    }
    return $return;
}

Help appreciated. Thanks.
GD.

zingbats

Please highlight or point out 253 and put your code in "

" tags

Alex.

ganga_din

line 253 is:

if (DB::isError($rsTmp = $this->_oConn->query($sql))) {

...

from perusing other post.. i am inclined to think that this is caused by the DB not being connected and I can't seem to find out why.. but any other input is also welcomed.. i am stuck until I figure this out...

ScubaKing22

To query a database you use mysql_query($query). Try adding the mysql_ and post what happens.

Weedpacket

From the look of the code (its mention of $this, mainly) I'm guessing that this is a method in an object. That object contains a property called oConn, which is apparently itself an object (the connection, I suppose). You're calling this connection object's "query" method, but you're being told that it doesn't have one. Maybe oConn is missing that method, or maybe it's not properly instantiated in the first place. Can't tell from here.

ganga_din

_oConn - is listed as a PEAR data object.

I can't find a connect statement in any of my code. it seems that it's all in the PEAR objects.

Added the mysql_query as:
$sql = "SELECT
news_type_id,
news_type
FROM
".PREFIX."_news_types";

     mysql_query($sql); -> added this and got the following error:

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /hsphere/local/home/gangadin/awarra.com/lib/classes/class.news.php on line 254

Talk about beating your head against a brick wall..

ganga_din

ok. I found the connect statement. And still can't fiqure it out.

I have attached the offending file.

I am sure it's a simple answer - if only I knew it.

GD.