Need Help query!!

[eluser]noobs[/eluser]
[quote author="JoostV" date="1269890557"]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');

[/quote]

thank you very very very very much master....your query working..haha...