Need Help query!!

[eluser]JoostV[/eluser]
I haven't seen your data model, but have you tried this?

Code:

// MAX(picture_id) returns the most recent picture, assuming picture_id is auto_increment
$this->db->select('*, user_id, user_name, picture_thumb, MAX(picture_id) as picture_id', false);
// Group by properti_id to return only one record per properti
$this->db->group_by('properti_id');

BTW, this looks like a syntax error:

Code:

$this->db->order_by('picture_id',1);