Select by active record... help

[eluser]sikko[/eluser]
Well, this is how I would do it:

Code:

$this->db->select('ur.id_url, ur.checktime, ur.result, ur.responsetime, ur.responselength, ur.responsespeed, uu.url');
$this->db->from('url_results ur, url_urls uu');
$this->db->where('ur.id_url', $urlId);
$this->db->where('uu.id_url', 'ur.id_url', false);

Please note the false in the last where clause. It's used for the field name not to be escaped.

Try it and let us know.