Login

03-28-2010, 11:14 PM

[eluser]noobs[/eluser]
hello all i am beginner to used code igniter so have a lot problem to develop...

this it my problem :

i have 3 table they are properti,picture and user..
i want to view at front page properti with thumbnail from picture table..one of properti have a lot picture...to be thumbnail picture on front page i want get last upload picture on either properti table...all this time i can't view what i want.. this is my query

Code:
$this->db->select('*,user_id,user_name','picture_thumb');

$this->db->where('properti_is_public', 1);

$this->db->join('picture','properti_id = picture_properti_id','LEFT');

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

$this->db->join('user','properti_user_id = user_id');

$this->db->limit($this->config->item('front_properti'));

$result = $this->db->get('properti');

any suggestion for my problem...

forgive me for my bad engglish...