<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class For_sale extends CI_Controller {

	public function index()
	{
		$data['page_title'] = "Homes for Sale";
		$data['tab_on'] = "forsale";
		$data['slider'] = false;
		$data['split'] = false;
		
		$gal_ids = explode(',', G_HOMES4SALE) ;
		
		$this->db->select();
		$this->db->from("ras_gallery as A, ras_gallery_phogal as B, ras_gallery_photo as C");
		$this->db->where_in("A.gal_id", $gal_ids);
		$this->db->where("B.gal_id = A.gal_id");
		$this->db->where("B.order = 1");
		$this->db->where("B.photo_id = C.photo_id");
		$this->db->order_by("A.gal_id", "ASC");
		
		$q =  $this->db->get();		
		$data['gdata'] = rset($q);
		
		$this->load->view('v_page_head',$data);
		$this->load->view('vHomesForSale');
		$this->load->view('v_page_foot');
	}
	
}

/* End of file welcome.php */
/* Location: ./application/controllers/welcome.php */