Login

07-10-2007, 07:06 AM

[eluser]champs[/eluser]
If it's not taking to anything, it's the spaces. I've never used that style, but here's how I would write the same query:

Code:
&lt;?php

$this->db->select('*');

$this->db->select('diary.id AS diaryID');

$this->db->from('diary');

$this->db->join('jobs',    'jobs.id=diary.jobID');

$this->db->join('users',   'users.id=diary.userID');

$this->db->join('clients', 'clients.id=jobs.clientID');

$this->db->limit(0, 30);

?&gt;

... and don't let anyone tell you to just use straight queries/bindings :p