Error with $this->db->list_fields() when using mysql/mysqli

Posted: 06 July 2008 04:41 PM

[ Ignore ]

Grad Student

Total Posts: 44

Joined 05-04-2006

When I use the db function list_fields on a table with dashes the tablename is not escaped and the query fails.


$this->db->list_fields('table-with-dashes');

results in the following query:


SHOW COLUMNS FROM table-with-dashes

which fails.

Expected query:


SHOW COLUMNS FROM `table-with-dashes`

This happens with CodeIgniter 1.6.3 and using bot mysql and mysqli db drivers.

Profile

Username		Remember Me?
Password		forgot password?

Visitor Statistics
The most visitors ever was 719, on June 06, 2008 10:16 AM
Total Registered Members:	62402	Total Logged-in Users:	31
Total Topics:	76628	Total Anonymous Users:	2
Total Replies:	413860	Total Guests:	413
Total Posts:	490488