Query for Show Tables?

[eluser]KingSkippus[/eluser]
If your database name is, say, blogdb, you can loop through like this:

Code:

$this->load->database();
$sql = 'show tables';
$sth = $this->db->query("SHOW TABLES LIKE 'fred%'");
foreach ($sth->result_array() as $row) {
  echo htmlentities($row['Tables_in_blogdb'])."<br />\n";
}