onchange to update a variable and pass it through to a query?

[lelliott92]

How can I make my on change in the form pass through the year thats been selected, then use that in the second query?

 

<select name="mySelect" onchange=""> 
	<?php $result= mysql_query('SELECT DISTINCT Year FROM MonthlySales'); ?> 
        <?php while($row= mysql_fetch_assoc($result)) { ?> 
            <option value="<?php echo htmlspecialchars($row['Year']);?>"> 
                <?php echo htmlspecialchars($row['Year']); ?> 
            </option> 
        <?php } ?> 
  </select> 
	     
    <?php

$query="SELECT * FROM MonthlySales WHERE Year = PASS YEAR SELECTED VARIABLE TO THIS BIT HERE";
		$results = mysql_query ( $query, $conn);

[smerny]

the query is PHP (server side code ran when the page is loaded)

 

onchange triggers javascript (client side code, ran when the menu changes.. well after the page is loaded)

 

---

 

you cannot make the client side code do something on the server side without loading... but you can use ajax to load data sort of "behind the scenes" and make changes from that.