I can get all "information_schema.columns" using:
PHP Code:
$this->db->getFieldData( $table );
But, how do I get only info on specific columns, like 'name' and 'type'.
I'm looking for the equivalent of:
PHP Code:
EXAMPLE: SELECT column_name, data_type FROM information_schema.columns WHERE table_name = '$table';
By default I get all these:
Code:
default, max_length, name, nullable, primary_key, type
I'm only interested in: