I am trying to figure out why this code doesn't work...

$res =& $d->query('SELECT * FROM s_news');
$res = $res->numRows();
while ( $row = $res->fetchRow( DB_FETCHMODE_ASSOC ))
{
$article_id = $row['id'];
}

When I try to load the entire php script it gives this error:

Fatal error: Call to a member function on a non-object in /home/virtual/site148/fst/home/scorpio/public_html/test.php on line 19

which is: while ( $row = $res->fetchRow( DB_FETCHMODE_ASSOC ))

I assume your using PEAR::DB?

The problem is probably because the query returned an error (thus, a DB_Error object) instead of the DB_Result object that you were expecting.

Try adding some error handling to it:

PHP Code:

if (DB::isError($res))
    die($res->getMessage());