displaying results from a drop down?

[adamhhh1]

Ok i have a drop down box which gets a load of entries from a database and populates the drop down. I then need to print to screen the currently selected option, but on the same page- no going to a new page etc.

$host = "localhost";
$user = "root";
$password = "!";
$database = "rio_test";

$connection = mysql_connect($host,$user,$password)
or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection)
or die ("Couldn't select database.");

echo "<select name=\"ticketName\" id=\"ticketName\">";
echo "<option>IPTIS Ticket Name</option>";
$query = "SELECT * FROM new_calculator";

$result = mysql_query($query)
or die ("This entry hasn't been found.");

while($row = mysql_fetch_array($result))
{

$ticket_name = $row['ticket_name'];
echo "<option>$ticket_name</option>";
}

//////// get the 3 lettered codes and return in a drop down box.
echo "</select>";
echo $ticket_name;

Is there a way to do this as I cant figure it out?

[severndigital]

not clear as to what your are looking to do.

can you explain more what you mean by the currently selected option?

did the user selected this, or was it selected by the code, or based off of query itself?

[adamhhh1]

sorry, the drop down is populated from a database- entry 1, 2, 3 etc etc then the currently selected is what the user chooses

[leatherback]

Yeah.. What is the problem you are facing?
You will always need to reload the page once a user selectes something, as the PhP code is processed on the server, and the browser only ever sees the (x)HTML the script produces.

In the code you could however have a test to see whether the form was submitted, and if it was, echo the $_POST-ed variable.

Please clarify what your question is, and where you are stuck
j

[TF_TheMoon]

If you want something to appear on the page when a user clicks a different entry in your drop down, you're going to need to use some Client side scripting. You could use AJAX to pull the information from the server onto the page, or alternatively load everything into hidden div tags and toggle the visiable options (or use sliding window techniques) to make the current one appear.

[adamhhh1]

dang yeh i was trying to see if there was a way without using AJAX

[leatherback]

Adam: Do you need to server to do anything? Or is it mor elike you auto-filling form items? You could than just use a javascript onchange(); command, and built a javascript function that fills divs on your page.
Just be aware that it is not fool-proove: people may surf without js turned on.