How can I retrieve the number of rows deleted with PDO?

[PUBLIC]

Okay, so I have been using a PDO wrapper for a project I'm working on, and I'm trying to find out whether a DELETE query was successful or not. Here is the code I am using:\[code\]/*** A pretty straight-forward query to delete a row from the verification* table where user_id is $user_id and code is $code*/$result = $this->database->query("DELETE FROM verification " . "WHERE user_id = %u AND code = %s", $user_id, $code);/** * This function will grab the PDO's exec() return, which should * return the number of rows modified. */if($this->database->getNumAffected($result) > 0) return true;else return false;\[/code\]The problem is, whether the DELETE query actually deletes a row or not, $this->database->getNumAffected($result) always returns '0'.You can check out the wrapper, but basically $this->database->getNumAffected($result) simply returns exactly the same value PDO::exec() would return.I tried this code without the wrapper (directly into PDO,) and I had the same problem but reverse: it always returned '1' (whether a row was deleted or not.)Any help would be greatly appreciated.EDIT: Based on this SO question, I'm doing everything right... I don't understand why this isn't working.