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 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
<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
Post a Comment