rrcfesc / codeignitercoredatabase

		$this->data_cache['table_names'] = array();

		$query = $this->query($sql);

		foreach ($query->result_array() as $row)

		{

			// Do we know from which column to get the table name?

			if ( ! isset($key))

			{

				if (isset($row['table_name']))

				{

					$key = 'table_name';

				}

				elseif (isset($row['TABLE_NAME']))

				{

					$key = 'TABLE_NAME';

				}

				else

				{

					/* We have no other choice but to just get the first element's key.

					 * Due to array_shift() accepting its argument by reference, if

					 * E_STRICT is on, this would trigger a warning. So we'll have to

					 * assign it first.

					 */

					$key = array_keys($row);

					$key = array_shift($key);

				}

			}

			$this->data_cache['table_names'][] = $row[$key];

		}

		return $this->data_cache['table_names'];

	}

		$query = $this->query($sql);

		$this->data_cache['field_names'][$table] = array();

		foreach ($query->result_array() as $row)

		{

			// Do we know from where to get the column's name?

			if ( ! isset($key))

			{

				if (isset($row['column_name']))

				{

					$key = 'column_name';

				}

				elseif (isset($row['COLUMN_NAME']))

				{

					$key = 'COLUMN_NAME';

				}

				else

				{

					// We have no other choice but to just get the first element's key.

					$key = key($row);

				}

			}

			$this->data_cache['field_names'][$table][] = $row[$key];

		}

		return $this->data_cache['field_names'][$table];

	}