sql parameter - Joomla! Forum - community, help and support


hi
i want display tables in database custom module way user can select table
so far have this
<field name="table1" type="sql" default="" label="select table" query="show tables" key_field="id" value_field="title"/> tried
<field name="table1" type="sql" default="" label="select table" query="show tables"/>
anyone has ideas of missing?
thanks

i have update if can me me super appreciate it
<field name="table1" type="sql" default="" label="select table" query="show tables" key_field="tables_in_database-name" value_field="tables_in_database-name" />
now because parameter
it work need somehow change database-name automatically figure out database install
ie:
if selecting table need #__
is there way select databse name?
thanks
manzanofab wrote:hi
i want display tables in database custom module way user can select table
so far have this
<field name="table1" type="sql" default="" label="select table" query="show tables" key_field="id" value_field="title"/> tried
<field name="table1" type="sql" default="" label="select table" query="show tables"/>
anyone has ideas of missing?
thanks





Comments

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

PProHeadless.exe has stopped working error when opening projects in Adobe Media Encoder CS6

Preconditions Failed. - Joomla! Forum - community, help and support