I've done something like this using an xml file. But how do you do something like this with a php form and data coming from a SQL Database.

can get data out of a selection list aka listbox, but now need to be able to select and move to and from the empty listbox.

this is an example of how i did it last year, which was an AJAX assignment. but not quite sure how to when reading from SQL.

_____________________________________________________________

function StudentManager ()
{
var students;
}

StudentManager.prototype.doIt = function(xmlDoc)
{
this.students = xmlDoc.getElementsByTagName("student");

var list = document.getElementById("slist");
var z=xmlDoc.getElementsByTagName("subject");
for(i = 0; i < z.length; i++)
{
if(z[i].attributes.getNamedItem("subjectName").nodeValue == "Interface Design")
{
var y=z[i].getElementsByTagName("student");
for(j = 0; j < y.length; j++)
{
var option = document.createElement("Option");
option.innerHTML = y[j].attributes.getNamedItem("surname").nodeValue + ", "+ y[j].attributes.getNamedItem("givenName").nodeValue;
option.value = y[j].attributes.getNamedItem("surname").nodeValue + ", "+ y[j].attributes.getNamedItem("givenName").nodeValue;
list.appendChild(option);
}
}
}
};

Thanks

Mous