Send email automatically with Code Igniter

[eluser]pickupman[/eluser]
Your code is very close to working. I would recommend using the following in your model

Code:

//Change
return $this->db->get();

//To
$query = $this->db->get();
if($query->num_rows() > 0)
  return $query->result();

return FALSE;

Right now, you are only returning the query object, not a field value. The corrected code will return the result object or FALSE if query fails. I can't tell from your query strings if you might be returning multiple rows or not. You will need to iterate through the result object and process accordingly.

Code:

$getmail = $this->Send_model->get_mail();

if($getmail != FALSE)
{
   foreach($getmail as $mail)
   {
     echo $mail->email;
   }
}