#40869 [Bgs]: Mysql gives incorrect result, using subqueries and variables

From: Date: Tue, 20 Mar 2007 21:34:36 +0000
Subject: #40869 [Bgs]: Mysql gives incorrect result, using subqueries and variables
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-110615@lists.php.net to get a copy of this message 
 ID:              40869
 User updated by: robert dot allen at unearthtravel dot com
 Reported By:     robert dot allen at unearthtravel dot com
 Status:          Bogus
 Bug Type:        MySQL related
 PHP Version:     5.2.1
 New Comment:

Hey

I have been playing with this some more and have found out that the
query returns the results I would expect if run through the mysqli
extension. I'm not sure if this gives you any further information as to
where the problem is but thought I would let you know in case it
indicates the problem is within php.

Thanks again

Rob


Previous Comments:
------------------------------------------------------------------------

[2007-03-20 18:56:08] tony2001@php.net

Your PHP uses mysql client libraries of different version, so I believe
it's some kind of client/server incompatibility.

------------------------------------------------------------------------

[2007-03-20 18:50:42] robert dot allen at unearthtravel dot com

The reason I reported it to php was due to the fact I get a different
result when executing it via php than a simple command line client.  

I presume you believe it to be a problem in the mysql dll's and
therefore their bug?

Thanks once again

Rob

------------------------------------------------------------------------

[2007-03-20 18:45:13] tony2001@php.net

Please report it to MySQL people.

------------------------------------------------------------------------

[2007-03-20 18:40:49] robert dot allen at unearthtravel dot com

the  select version() query gave:
5.0.33

I am also using those dlls now

Thanks

------------------------------------------------------------------------

[2007-03-20 18:25:16] tony2001@php.net

And try php_mysql.dll from here:
http://dev.mysql.com/downloads/connector/php/

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/40869

-- 
Edit this bug report at http://bugs.php.net/?id=40869&edit=1

Thread (12 messages)

« previous php.bugs (#110615) next »