Changing a php variable when a option in a drop-box is selected

[vicious]

Okay I have:

<select name="x">

<option value="1">
<option value="2">

</select>

Now, how do I set the variable $y to 1
The variable will be used on the page, and the page can't be refreshed.
Any help?

[vicious]

A different aproach that I just thouht of is to refresh the page, but how do I do that?
Oh, Instead of using refresh, i want to use the absolute address

[nagasea]

your code is kinda weird, and i dont know what you want.
can you provide more information

[vicious]

K,
I have a drop box.
How do I open a page when a option is selected?

[matt_4013]

<select name="x" onchange="submit();">

[sijis]

i'm guessing what you might be looking for, but i think it might be this:

http://webdeveloper.earthweb.com/webjs/jsnavigation/item.php/105511

now, if you trying to use strictly php, you can somewhat simluate that effect using this code.

file.php

<form method="post" action="redirect.php">
<select name="x">

<option value="1">
<option value="2">

</select>
</form>

redirect.php

<?php
switch($_POST['x']){
case 1:
header("Location: http://www.domain-one.com");
exit();
case 2:
header("Location: http://www.domain-two.com");
exit();
default:
echo "You got an error. No value was selected";
exit();

}
?>

[vicious]

What I was trying to do in the first place was to create two drop-boxes the first

<select name="x">

<option value="1">
<option value="2">

</select>

and the seconded

<select name="y>

<option value="1">
<option value="2">

</select>

Now, the options on both came from a database:
x's database query
SELECT FROM x
and y's
SELECT FROM y

Now, I want to change it so
SELECT * FROM y WHERE x=$x

So, each time you change the option on x, you get y's query updated, and the drop-box changed

I wanted this to hapen WITHOUT reloading the page
THATs where I need help

okay
now what do you think

[The_Chancer]

It is possible to do - but with Javascript not PHP...

However you can get it to work....

Have a look at this....

$query=do_query("SELECT company,category FROM suppliers");
		while(list($company,$category)=mysql_fetch_row($query))
		{
			$category=explode("\n",$category);
			foreach($category as $string)
			{
				$string=trim($string);
				$array .="\"".$company."\",\"".$string."\",";
			}
		}
		$array=substr($array,0,-1);
		?>
		<script language="JavaScript">
		var supplier_toCategoryMap = new Array(
		<? echo $array;?>);
		function supplier_popCategory(supplier, category) {
		  var   manCode = supplier.options[supplier.selectedIndex].value;
		  var   i, j;

	  j = category.options.length = 1;
	  category.options.selectedIndex = 0;

	  for(i=0; i<supplier_toCategoryMap.length/2; i++) {

	    if (supplier_toCategoryMap[i*2] == manCode) {

	      category.options.length = j+1;
	      category.options[j].value = supplier_toCategoryMap[i*2+1];
	      category.options[j].text = supplier_toCategoryMap[i*2+1];
	      j += 1;
	    }
	  }
	return;
	}

That bit sets up the initial array for the boxes - and associates which items should be shown in the second box with those shown in the first dropdown

array looks like ("box1","Item 1","box1","item 2","box1","item 3","box2","Item 4","box2","item 5")

Then this

<select name=\"supplier\" onChange=\"supplier_popCategory(this, this.form.category)\" class=\"textbox\">
			<option value=\"\" selected>Please Choose</option>");
			$query=do_query("SELECT company FROM suppliers");
			while(list($company)=mysql_fetch_row($query))
			{
				print("<option value=\"$company\">$company</option>
				");
			}
			?>
			</select>

Shows the main select box to choose the initial choice
and this

<select name=\"category\" class=\"textbox\"><option value=\"\" selected>Please Choose</option></select>

Is the dynamically created dropdown select box...

Hope it helps....

[vicious]

Thanks,
to highlight:

<?
$query=do_query("SELECT company,category FROM suppliers"); 
        while(list($company,$category)=mysql_fetch_row($
query)) 
        { 
            $category=explode("\n",$category); 
            foreach($category as $string) 
            { 
                $string=trim($string); 
                $array .="\"".$company."\",\"".$string."\","; 
            } 
        } 
        $array=substr($array,0,-1); 
        ?> 
        <script language="JavaScript"> 
        var supplier_toCategoryMap = new Array( 
        <? echo $array;?> ); 
        function supplier_popCategory(supplier, category) { 
          var   manCode = supplier.options[supplier.selectedIndex].value; 
          var   i, j; 

      j = category.options.length = 1; 
      category.options.selectedIndex = 0; 

      for(i=0; i<supplier_toCategoryMap.length/2; i++) { 

        if (supplier_toCategoryMap[i*2] == manCode) { 

          category.options.length = j+1; 
          category.options[j].value = supplier_toCategoryMap[i*2+1]; 
          category.options[j].text = supplier_toCategoryMap[i*2+1]; 
          j += 1; 
        } 
      } 
    return; 
    } 
    </script>

This may be asking for too much but,
how will i incorporate it into this coding:

<?

  echo '<form action="add3.php">Choose the console here';

  mysql_connect() or die ("Problem connecting to DataBase"); 
  $query = "SELECT * FROM console"; 
  $result = mysql_query("$query");  
    if($result)
      { 
        echo '<select name="console">'; 
        while ($r = mysql_fetch_array($result))
          { 
            $id = $r["id"]; 
            $console = $r["console"]; 
            echo '<option value="$console">$id :: $console'; 
          }
        echo '</select>'; 
      }
    else
      { 
        echo '<br>No consoles in database.'; 
      }

  echo '<br>Choose the game here';

  $query = "SELECT * FROM game"; 
  $result = mysql_query("$query");  
    if($result)
      { 
        echo '<select name="game">'; 
        while ($r = mysql_fetch_array($result))
          { 
            $id = $r["id"]; 
            $game = $r["game"]; 
            echo '<option value="$game">$id :: $game'; 
          }
        echo '</select>'; 
      }
    else
      { 
        echo '<br>No consoles in database.'; 
      }

  echo '<br>Enter the cheat here: <input name="cheat"></input><input type=hidden name="type" value="cheat"><br><input type="submit" value="submit"></form>';

}

  else

{

  echo 'Sorry, this page requires more information.  Click <a href="add.html">here</a> to go back.';

}

?>