Can't perform a UNION ALL MySQL query

[eluser]bretticus[/eluser]
Not the only way to do it. Research sub queries at MySQL docs site. Also, the real benefit to active record is that you should be able to use any type of database w/o changing your model code. Just use a normal query since your sql is MySQL specific.


Simple ex. using query()

Code:

<?php

$query = $this->db->query("YOUR QUERY");

if ($query->num_rows() > 0)
{
   foreach ($query->result() as $row)
   {
      echo $row->title;
      echo $row->name;
      echo $row->body;
   }
}?>