Get Column Names - Joomla! Forum - community, help and support

i have been trying names of columns in table , returns array object. returns blank. there native class returns array of column names? here simple example of query.

code: select all

public function getcolumns() {
               $db    = $this->getdbo();
             $query = "show fields #__table_tabs";
            $db->setquery($query);
            $db->loadobject();
             }

thanks

i believe issue syntax. notice using fields instead of columns.

for example, display column details of table jos_content is:

code: select all

show columns jos_content;