[Phpmyadmin-devel] Display multiple query results

Michal Čihař 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 [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.

	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20120718/5d584a86/attachment.sig>

More information about the Developers mailing list