title: Running multiple queries in model in codeigniter
body: <p>I have this code in model in codeigniter:</p>
  
  <pre><code>&lt;?php
  Class Mymodel Extends CI_Model
  {
      function __construct()
      {
          parent::__construct();
      }
  
      function search($textinput)
      {
          $street = "select street from dataSearch;";
          $stripNameWOSpace = "select stripNameWOSpace FROM dataSearch;";
          $vowels = array('a','e','i','o','u',';','/','-', ' ');
          $string = strtolower($textinput);
          $strippedVowels = mysql_real_escape_string(str_replace($vowels, '', $string));
              $this-&gt;db-&gt;query("select dataSearch.id,
                  dataSearch.name,
                  dataSearch.street,
                  dataSearch.city,
                  dataSearch.lat,
                  dataSearch.lng,
                  category.asiatype from dataSearch join category on dataSearch.cat = category.id
                  where dataSearch.street like '%".$textinput."%'");
              $this-&gt;db-&gt;query("select dataSearch.id,
                  dataSearch.name,
                  dataSearch.street,
                  dataSearch.city,
                  dataSearch.lat,
                  dataSearch.lng,
                  category.asiatype from dataSearch join category on dataSearch.cat = category.id
                  where dataSearch.stripNameWOSpace like '%".$strippedVowels."%'");
              $query = $this-&gt;db-&gt;get();
              $query-&gt;result();
  
      }
  }
  ?&gt; 
  </code></pre>
  
  <p>I just want to execute multiple queries. You notice in where statement the two have different condition. I just want to get the result for the two queries.
  I try the switch statement to execute both queries and it is not working. Help me.</p>