[Phpmyadmin-devel] Display multiple query results
michal at cihar.com
Wed Jul 18 15:16:09 CEST 2012
Dne Tue, 17 Jul 2012 10:38:32 +0530
Chanaka Dharmarathna <pe.chanaka.ck at gmail.com> napsal(a):
> I'm trying to implement titled case related to bug .
> 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
> Additionally I saw mysql_multi_query manual  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
I think Rouslan might have some ideas here as well as he is quite
familiar with stored procedures and related stuff.
Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 836 bytes
Desc: not available
More information about the Developers