Pear:: problem with numRows()

[cleromancer]

I'm having a poo of a night. I'm trying to transfer MySQL to PEAR but I am having troubles displaying results. The query returns values when run through my mysql query... But now that I go to PEAR:::::: There is no error from the database (as shown in the code), but when I try to retrieve the value from the results it dies.

This dies for fetchRow() as well.

Any help would be appreciated.

Michael.

This is the screen output

[][Object]
Fatal error: Call to undefined function: numrows() in /home/digitala/public_html/classes/class-auth.php on line 55

This is the code

$query = "SELECT * FROM usr";

$db = DB::connect( "mysql://$dbuser:$dbpass@$dbhost/$dbname" );
$db->setFetchMode(DB_FETCHMODE_ASSOC);

echo "[".$result."]";
$result = $db->query($query); 

if (DB::isError($db)) {
  die ($db->getMessage());
}

echo "[".$result."]";
$numRows = $result->numRows();  // ERROR IS WITH THIS LINE. 
$db->disconnect();

[[deleted]]

It's obviously that you use an undefined(maybe you do,but you didn't use "inculde" or "require" to include it) founction numRows();
Try this....
Sincerely,

[guyryan100]

The trouble is that your query didn't return a valid result. Therefore the object returned is an error rather than result. (thus the undefined function). Maybe the wrong table name or something. Here's how to check it.

Add this code after you call $db->query($query); .....

if (DB::isError($result)) { // Check the result object in case there
die($result->getMessage()); // was an error, and handle it here.
}

This will give you the mysql error message. Your current error checking will only identify an error in the connection to the database.

Hope this helps.....

[toma42]

Look into the pear error handling too. You can setup a specific function to call when a pear error is encountered. You can then rely on this function rather than manually checking through DB::isError() after every query.