Re: Weird result set from PEAR's DB
| From: | Daniel Convissor | Date: | Tue, 29 Mar 2005 19:03:57 +0000 |
| Subject: | Re: Weird result set from PEAR's DB | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-36965@lists.php.net to get a copy of this message | ||
On Tue, Mar 29, 2005 at 10:58:37AM -0800, Joe Stump wrote:
> Oddly enough changing the query from:
> SELECT * FROM users WHERE username='foo@example.com'
> to:
> SELECT * FROM mydb.users WHERE username='foo@example.com'
And what happens when you check the result for errors?
$res =& $db->query("SELECT * FROM users WHERE
username='foo@example.com'");
if (DB::isError($res)) {
echo $res->getDebugInfo() . "\n";
} else {
echo "The query ran fine\n";
}
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409