consulting variable

You didn't grab the result from the executed query and access the 'country' column from the result

PHP Code:

$country = $this-> db- > query ("select country from users where email = '$email' and password = '$password' " ) ;

//execute the query
$executed = $country->result(); //normally I'd add ->result() to the above query...

//grab the country field from the result
$var_country = $executed->country; 


sorry, did not get it right , could explain me better , could give a real example of how would this query ?

thanks mate