Re: Weird result set from PEAR's DB

On Mar 29, 2005, at 11:57 AM, Joe Stump wrote:

BTW, to anyone who cares. I can copy and past the query from echo '<pre>'.$sql.'</pre> into my mysql terminal and it returns boned results in both the linux and OSX client. This appears to be a strange mysql bug of some sort. To add to the oddness my query doesn't show any out of the ordinary characters in it when I open it in bvi. Also, this query fails: SELECT *

                FROM users
                WHERE userID='0'

While this query written into the term by hand works: select * from users where userID='0'

Beware of copying code from browsers- you're likely to get some weird characters (which look normal). -ryan

*VERY* odd ... --Joe -- Joseph C. Stump joe@joestump.net http://www.joestump.net On Mar 29, 2005, at 11:34 AM, Joe Stump wrote:

There is no error. The array I showed you is the result of my $result->fetchRow(). Everything works fine, except that the keys are completely boned. I've tracked the problem down further and found that the raw response from the line in DB_mysql::fetchInto() is returning a boned array:

            $arr = @mysql_fetch_array($result, MYSQL_ASSOC);

A print_r on $arr gives me this: Array (

    [@] => 1
    [

@] => joe@joestump.net

    [
] => 1
    [	@] => 1

) Other queries work just fine. It's quite strange. --Joe -- Joseph C. Stump joe@joestump.net http://www.joestump.net On Mar 29, 2005, at 11:03 AM, Daniel Convissor wrote:

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 -- PEAR Development Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PEAR Development Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PEAR Development Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- http://theryanking.com/