php and list box question

[excl209]

I have the following code on a page... but I want it to be able display the record selected from the list box... this is what I have right now:-

 

$query = "SELECT * FROM users";
$result = mysql_query($query) or die ("Error in query" . mysql_error());



for($i = 0; $i < mysql_num_rows($result); $i++) {
$row = mysql_fetch_array( $result );

$TheList .= "<option> $row[first_name] </option> <br>";

}


echo "Select First Name:   ";

echo "<select first_name='first_name'>";

echo $TheList;

$student = first_name;

echo "</select>";


echo "<br><br><br>";

echo "Your selection was : $student ";

 

Thanks,

Excl209

[Dragen]

if you're wanting it to happen when a user selects an option without reloading the page you need to use javascript or ajax.

 

to use php to do that you'd need to refresh the page.