Select country name from session
<p>I have web site that get data of company from database, but here I have bi problem.</p>

<p>when I do select query to get all company from <code>DB</code>, the site will be load more than 5 min.</p>

<p>So I need to make select all company from <code>DB</code> that include on user country by get country from browser and put it on session.</p>

<p>So what is the solution for this problem ?</p>

<p>This is my query :</p>

<pre><code>    public static function selectallcompanydautocomplate()
    {
        $query = mysql_query("SELECT DISTINCT company_CompName FROM company");
        return $query;
    }
</code></pre>
