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

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: 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 Previous Comments: ------------------------------------------------------------------------ [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/ ------------------------------------------------------------------------ [2007-03-20 18:23:52] tony2001@php.net Run "select version()" on the server ------------------------------------------------------------------------ [2007-03-20 18:15:52] robert dot allen at unearthtravel dot com The xampp bundle was installed on windows xp, our hosted server is a linux system ------------------------------------------------------------------------ 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