Ravi,
I had a similiar issue and found that the mysqli driver needs an additional parameter seeded into it. Now, I haven't added this into the phpAdmin system, but I can show you what needs to be added.
Wherever the call is made in the phpAdmin code to call your stored procedure or inline SQL you must adjust the the system as follows:
PHP Code:
if (function_exists(‘mysqli_options’)) {
mysqli_options($this->_connectionID, /*CLIENT_MULTI_RESULTS*/0×20000, 1);
}
This information was taken from:
Geek Building The Bridge Part 2 » Blog Archive » PHP Adodb’s mysqli call-stored-proc patch
I did use this with the PHP ADODB library set and posted my fix at:
Help please with adodb calling stored procedure in mysql db - PHPBuilder.com
Hope this helps!
Kind Regards,
Chris Danielson
MaxPowerSoft, LLC