Loading a combo box with branch names I'm using this way to load a combo box with branch names, but it's taking more time if there is more number of data.

Is there a better way to do this, like binding in PHP?

&lt;select name="CmbBr" id="CmbBr"&gt;                                            
  &lt;?php                                          
     include ("dbcon_.php");
     $sql = mysql_query("SELECT BranchName FROM TblBranch ORDER BY BranchName ASC");
     if(!mysql_num_rows($sql) == 0)
     {
        while($row = mysql_fetch_array($sql))
       {
           ?&gt;
              &lt;option value="&lt;?php echo $row["BranchName"];?&gt;"&gt;&lt;?php echo $row["BranchName"]; ?&gt;&lt;/option&gt;
           &lt;?php
       }
     }
  ?&gt;
&lt;/select&gt;
I'd just like to note that use of the mysql_* functions are going to be deprecated in the next version or the one after than(link at the end). You should start using mysqli or PDO. 

http://news.php.net/php.internals/53799