Welcome Guest, Not a member yet? Register   Sign In
Else condition error in model
#1
Exclamation 

Hi, Trying to learn Codeigniter. I have this form where I am trying to load dropdown value from db.

I if I use this code in model, it works fine:
Code:
    function getData($loadType,$loadId){
        if($loadType=="state"){
            $fieldList='id,v_state_name as name';
            $table='vbc_state';
            $fieldName='country_id';
            $orderByField='v_state_name';
        }else{
            $fieldList='id,v_state_region as name';
            $table='vbc_state_region';
            $fieldName='v_state_id';
            $orderByField='v_state_region';
        }
        $this->db->select($fieldList);
        $this->db->from($table);
        $this->db->where($fieldName, $loadId);
        $this->db->order_by($orderByField, 'asc');
        $query=$this->db->get();
        return $query;
    }

Since I need one more field to load, and I add this, I get error:

Code:
    function getData($loadType,$loadId){
        if($loadType=="state"){
            $fieldList='id,v_state_name as name';
            $table='vbc_state';
            $fieldName='country_id';
            $orderByField='v_state_name';
        }else{
            $fieldList='id,v_state_region as name';
            $table='vbc_state_region';
            $fieldName='v_state_id';
            $orderByField='v_state_region';
        }else{
            $fieldList='id,v_city as name';
            $table='vbc_city';
            $fieldName='v_state_region_id';
            $orderByField='v_city';
        }
        $this->db->select($fieldList);
        $this->db->from($table);
        $this->db->where($fieldName, $loadId);
        $this->db->order_by($orderByField, 'asc');
        $query=$this->db->get();
        return $query;
    }

Parse error: syntax error, unexpected 'else' (T_ELSE) in C:\xampp\htdocs\drop\application\models\model.php on line 28


Is there anything wrong with this code?
Reply


Messages In This Thread
Else condition error in model - by Codeigniter_Learner - 12-25-2015, 09:48 AM
RE: Else condition error in model - by skunkbad - 12-25-2015, 01:18 PM
RE: Else condition error in model - by Php - 12-25-2015, 10:49 PM



Theme © iAndrew 2016 - Forum software by © MyBB