Displaying dynamic results on a table

CensorNet

Hello all,

I would like to create a section in my app that it will allow me to run queries to the database from simple SELECT, UPDATE to join queries. Then I would like the result of the sellect query to be displayed.
This should work dynamically I guess in order to work correctly.
Is there something that can help me do that?
Please feel free to ask me anything if i have not explained very well.

Thanks a lot.

allan

Sounds like you are describing the functionality of Editor. Is that what you are looking for?

Allan

CensorNet

Hello Allan, Thanks for the reply.
Nop. I am already using that:).
What i mean is that, i want to have a text box to run queries from that and get the result displayed in the front end dynamically.
does the editor have any support for dynamic tables?

allan

i want to have a text box to run queries from that

As in your want to be able to search the existing table, potentially with complex SQL queries?

It is certainly possible to use complex where conditions if you are using the Editor PHP class (since you are already using Editor :-) ). The documentation for it is available here.

Allan