Hi
Dne Tue, 17 Jul 2012 10:38:32 +0530 Chanaka Dharmarathna pe.chanaka.ck@gmail.com napsal(a):
I'm trying to implement titled case related to bug [0]. In current code, any SQL going to executed via SQL window, is processed and if there are more SQL queries, it detect only one query. So whole statement with any valid number of SQl queries need to be detected. Then by using mysql_multi_query() function all results related to multiple queries can be obtained. As I think displaying these results can be done with looping the result sets.
Additionally I saw mysql_multi_query manual [1] mentioned that separate queries are identified by semicolon. May be I need to replace the delimiter if it is not a semicolon.
It is not possible to replace it in all cases - eg. when creating procedures. So it might be better to run mysqli_query and collect results manually?
I think Rouslan might have some ideas here as well as he is quite familiar with stored procedures and related stuff.