How to put data from database to Combo box

<select name="cboDesignation" class="txtbox" id="cboDesignation" style="width:150px" tabindex="1">
<option value="">Select One</option>
                    <?php
$sql="SELECT intDesignationId,strDesignation from designation WHERE  intDesignationStatus=0";
$result = $db->RunQuery($sql);
while($row = mysql_fetch_array($result))

{
        ?>
<option value="<?php echo $row['intDesignationId']; ?>"><?php echo $row['strDesignation']; ?></option>
               
                 <?php
}

?>
                </select>