Weird result set from PEAR's DB
| From: | Joe Stump | Date: | Tue, 29 Mar 2005 18:58:37 +0000 |
| Subject: | Weird result set from PEAR's DB | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-36963@lists.php.net to get a copy of this message | ||
I'm getting weird result sets:
Array
(
[@] => 1
[
@] => foo@example.com
[] => 1
[ @] => 1
)
Anyone seen anything like this before? It works fine on other databases, but querying this one table results in screwed up result sets. Oddly enough changing the query from:
SELECT * FROM users WHERE username='foo@example.com'
to:
SELECT * FROM mydb.users WHERE username='foo@example.com'
Fixes the problem. I know it's no my code/query since this is in one of my base classes in software that has been installed on numerous systems over the last 2 years (not to mention running in various production sites all of that time as well).
One other hint to the problem is that I'm connecting from my local OSX install to my dev DB server (linux) on an internal network. Running from my dev site, which runs on the dev/DB server works fine (as does my live site which runs a similar setup in the NOC - only it's linux connecting to linux).
Ideas?
--Joe
--
Joseph C. Stump
joe@joestump.net
http://www.joestump.net