Populating an HTML ListBox

[CraigMuckleston]

I have the following php code that retrieves a list of items. I want to populate a listbox with the XMLHttpRequestObject, but I am getting 1 long string instead of each item on a line. How can I populate the listbox correctly:

<?php
 
$dsn="Driver={SQL Server};Server=myserver;Database=mydb;";
$username="user";
$password="pwd";
 
$sqlconnect=odbc_connect($dsn,$username,$password);
$sqlquery="SELECT item, description
           FROM db..tbl1 (nolock)
           WHERE item LIKE '" . $_GET['q'] . "%'
           OR description LIKE '%" . $_GET['q'] . "%'
           AND item_status = 'A'";
$process=odbc_exec($sqlconnect, $sqlquery);
 
while(odbc_fetch_row($process)) 
{ 
    $item = odbc_result($process,"item");
    $description = odbc_result($process,"description");
    $supdet = $item.' - '.$description;
                echo $supdet;
}
odbc_close($sqlconnect);
 
?>
 

My javascript code to handle the income responseText is:

function getList(dataSource)
{  
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");  
  xmlHttp.onreadystatechange=function()
  {
    if(xmlHttp.readyState==4)
      {
     document.getElementById("autoListResults").add(new Option      (xmlHttp.responseText, xmlHttp.responseText));
     document.getElementById("autoListResults").style.visibility = "visible";
      }
  }
xmlHttp.open("GET","server2.php?q=" + dataSource, true);
xmlHttp.send(null);
}
 

< Please use [code] tags when posting code! -Atli >

[kovik]

I'm still playing around with AJAX myself, but I believe that the easiest way to split up all of those items is to have them formatted as an XML file, each an <item>.