How do I do "while fetching" in CodeIgniter?

Question

What is the equivalent code that will run the code, get and write all the variables ...

Here's what I would normally do like this:

$get = mysql_query("SELECT * FROM aTable");

while($row = mysql_fetch_assoc) {
echo $row['someContent'];
}

How can I do this in codeigniter?

+3

PeaceDealer 18 jan. 13 at 20:14

1 answer

Rocket hazmat · Accepted Answer · 2013-01-18T20:20:18+0000

After executing the query, use ->query()

either the "active record" class ->get()

using the method result_array

.

$query = $this->db->query("SELECT * FROM aTable");

foreach($query->result_array() as $row){
    echo $row['someContent'];
}