Execute php code from Listbox

Hi,
Im starting to write a simple (so I thought! ) project at work, I have no problems with the HTML, CSS or even the php mysql setup, but I am struggling with a simple piece of code!

I have a list box, that populates from a table column using the following code:
[php]<?php
function select()
{
$query=“SELECT appname FROM kpe_apps”;
$result = mysql_query($query);
echo ‘’;
while($nt=mysql_fetch_array($result)){
echo ‘’ . $nt[‘appname’] . ‘’;
}
echo ‘’;
}
?>[/php]

I then called the function on the page I needed. which works fine,
now all I need is whatever is selected in the listbox other columns in the same table relating to the selected item are seen.

I just cant seem to do it, loads of people are using jquery and other code, surely this can be done in php?

any help would really be appreciated…
Many Thanks

Sponsor our Newsletter | Privacy Policy | Terms of Service