• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Model query with two possible inputs

#1
[eluser]kirkaracha[/eluser]
I have a list of countries I can access publicly or via a password-protected admin backend. I want to access the countries by URL name from the front end for SEO/usability reasons, and I want to access them by ID on the backend (in case I need to edit the URL name). Here's the query from my model:
Code:
function get_country_info($country_id = null,$country_url_name = null) {
    $this->db->select('
        country_id,
        country_name,
        country_url_name
    ');
    $this->db->from('countries');
    if($country_id != null){
        $this->db->where('country_id',$country_id);
        $this->db->limit('1');
    }
    if($country_url_name != null){
        $this->db->where('country_url_name',$country_url_name);
        $this->db->limit('1');
    }
    return $this->db->get();
} // get_country_info
This works fine if I use ID, but doesn't return any records when I use the URL name. Is there something wrong with my model? How should I do this?

Thanks.


Messages In This Thread
Model query with two possible inputs - by El Forum - 07-31-2007, 12:50 PM
Model query with two possible inputs - by El Forum - 07-31-2007, 01:50 PM
Model query with two possible inputs - by El Forum - 07-31-2007, 03:37 PM
Model query with two possible inputs - by El Forum - 07-31-2007, 04:16 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.