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

ID: 40869 Updated by: tony2001@php.net Reported By: robert dot allen at unearthtravel dot com Status: Feedback Bug Type: MySQL related PHP Version: 5.2.1 New Comment: And try php_mysql.dll from here: http://dev.mysql.com/downloads/connector/php/ Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2007-03-20 18:12:10] tony2001@php.net Which OS is that? ------------------------------------------------------------------------ [2007-03-20 18:07:52] robert dot allen at unearthtravel dot com To be honest I am not sure how to do this, I have tried it on an xampp bundle though and so presume they would have linked them correctly. I have also tried on our hosted managed server and get the same result in both places. Thanks for your help Rob ------------------------------------------------------------------------ [2007-03-20 17:45:35] tony2001@php.net Make sure PHP is linked with the correct libmysql, it should be of the same version as the server. ------------------------------------------------------------------------ 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