Welcome Guest, Not a member yet? Register   Sign In
Need help with database querys
#2

[eluser]Twisted1919[/eluser]
Code:
//model function:
function get_entry($entry_id){
$sql='SELECT b.*,u.* FROM blogs b INNER JOIN users u ON u.user_id=b.user_id
WHERE b.entry_id=?';
$query=$this->db->query($sql,array($entry_id));
return $query->num_rows() > 0 ? $query->row() : NULL ;
}


//controller
if($entry = $this->model_name->get_entry(123))
{
   echo $entry->username;
}


Messages In This Thread
Need help with database querys - by El Forum - 01-31-2011, 07:00 AM
Need help with database querys - by El Forum - 01-31-2011, 07:28 AM
Need help with database querys - by El Forum - 01-31-2011, 07:46 AM



Theme © iAndrew 2016 - Forum software by © MyBB