Noob w/ Select issues

[eluser]ggoforth[/eluser]
You also don't need to assign the $query variable to each part of the active record. You technially only have to assign the variable to the ->get() to hold the result. You could rewrite it as:

Code:

$this->db->select(‘code, expires_dt, amount’);
$this->db->from(‘promotions’);
$this->db->where(‘code’, $coupon_code);
$query = $this->db->get();
if ($query->num_rows() > 0)
{
   $row = $query->row();

   echo $row->title;
   echo $row->name;
   echo $row->body;
}