combo box sorted order

Hi All,
    I am retrieving values from database and inserting into combo box.
in SELECT statement i used, order by ASC. the values are comming in ascending order but when i see the values in combobox, then are not in sorted order. Can someone please tell me how to display combobox in sorted order.
Thanks,
keerthimothukuriAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
WhiteMageConnect With a Mentor Commented:
Does this help?
//SQL Query
'SELECT * FROM Table ORDER BY Field ASC'
 
//XHTML
<body>
  <select id="combobox">
    <option>&nbsp;</option>
  </select>
</body>
 
//Javascript
var rows; //rows from sql query
var select = document.getElementById('combobox');
 
while(select.hasChildNodes()) {
  select.removeChild(select.firstChild);
}
 
for(var i = 0; i < rows.length; i++) {
  var option = document.createElement('option');
  option.appendChild(document.createTextNode(rows[i]));
  select.appendChild(option);
}

Open in new window

0
 
CEHJCommented:
How are you getting them into the combo? (please post code)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.