kieronjones

Hi, I'm wokring on a little piece of code and really needs some help. Here's the code that I have $query = "SELECT first_name, last_name, email_address, btnumber, league FROM tb_user WHERE league = $league"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo $row['first_name']. " - ". $row['last_name']; echo "<br />"; } This works fine however what I would like to be able to do is 2 things. Firstly, store each row of results in individual arrays which I can use later. I would then like to be able to create a drop down menu, the values being $row['first_name'] & $row['last_name'] from each row of database results eg. So the user can select a specific person from the dropdown menu. Thanks for any guidance and help offered. Kiz