[eluser]rochellecanale[/eluser]
hello guys how can i display all the databases in mysql using active record or tradational query?
something like:
Code:
<?php
$showdatabase = "SHOW DATABASES";
$resultshow = $this->db->query($showdatabase);
foreach($resultshow->result_array() as $row){
?>
<tr>
<td>
<?php
echo "<label>".$row['']."</label>"; //dont know how can i get the list of databases
?>
</td>
</tr>
<?php
}
?>