Pass value from listbox to listbox?

[Timm]

I'm not sure if this is a PHP question or an HTML question.

Short version: When the user selects an item from a list box, is there a way to make another list box on the same form immediately display the same value?

Long version: My page1.php collects user-specified data to build a query and pass the query to page2.php, which then displays the requested data in table format.

Some entry fields allow the user to specify a range. Two copies of a listbox containing the same values are listed for "FROM" and "TO" selections.

<select name="FROM1">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
</select>

<select name="TO1">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
</select>

Currently, if the user selects a FROM1 value only, the query searches for data >= FROM1. If only a TO1 value is selected, the query searches for data <= TO1. If both values are entered, the query searches for >=FROM1 AND <=TO1.

What I want to be able to do is save users a step if their intention is to search for a single item instead of a range of items. When a user selects "B" from FROM1, is it possible for TO1 to automatically default to a checked or selected value of "B", too?

Thanks!

Timm

[gutlass]

If you want to use some javasript in combination with your PHP that would work. You can make the value of the 2nd drop down menu be auto updated when the first drop down changes.

or could have it submit to another page and pass the variables through a form.

[bastien]

to do this is to check on the serverside via php

check for both values
if one is null then create the sql query to check for only that one item
else
check for both

hth

[hrosas]

This is client side not server side, so this is a javascript thing. PHP only read a php file, parse it and most of time sends html, so, it's better to use javascript in this case.

Hector

http://www.oksonora.com

[Timm]

I tried adding an onClick event to the <SELECT name="FORM1"> tag. I couldn't get it to work. Do I need to use an onClick event? How do I do it?

I tried:
<SELECT name="FORM1" onClick"TO1 = FORM1;">
Nothing happened.

Then:
<SELECT name="FORM1" onClick"<? TO1 = FORM1; ?>;">
Received a parse error.

Any ideas? Thanks!

Timm

[bastien]

<?
$sql="select * from data ";

if ((isset($POST['FROM1']) && (isset($POST['TO1'])){
$sql.= "=>".$POST['FROM1']." AND <=".$POST['TO1'];
}elseif (isset($POST['FROM1'])){
$sql.= ">=".$POST[' FROM1'];
}elseif (isset($POST['TO1'])){
$sql.= "<=".$POST[' TO1'];
}

$result = mysql_query($sql);

hth

[Timm]

bastien,

If I am interpreting your code correctly, you are telling me how to define the query to get the results I want. My problem is not with the query. I am already getting the results I want.

What I want to know how to do is to immediately pass a value selected in one list box to another list box (before the query is processed).

For each query selection that can include a range of values, I am displaying two listboxes with identical values from which to select. If the user enters a FROM value only, the results will include all values >= to the selected value. If the user enters a TO value only, the results will include all values <= to the selected value. If the user enters two different values, the program automatically makes the entries a valid range and provides the matching data within the valid range. All I want to do is save users a step IF they are attempting to process an EQUAL TO for this query selection. When the user sets the value of the FROM box ("B"), I want the TO box to automatically display the same value ("B"), essentially adding a name="B" to the query; the query itself is not being processed yet.

Is it possible to immediately update the displayed value of a second listbox when a selection is made from the first listbox?

Again, thanks!

[wilsonodk]

Originally posted by Timm
I tried adding an onClick event to the <SELECT name="FORM1"> tag. I couldn't get it to work. Do I need to use an onClick event? How do I do it?

You'll need an onChange event.
Used like this

<SELECT name="FORM1" onchange="listboxfunc()">

The [FONT=courier new]listboxfunc()[/FONT] would be a JavaScript function that would take the value of the list box and change the value of another listbox.

Take a look at:
JavaScript.com
Webmonkey

HTH