I've got a form with a pulldown on my main page. The user chooses from the pulldown and that is passed to the secondary page. That variable is supposed to search the database and display the results.
However, the secondary page is not getting the variable. It shows in the URL,
but it shows
as 0 in the DB query.
Here's the form code:
<form id="bytitle" action="bytitle.php" method="get" name="bytitle"
enctype="text/plain">
<div align="center">
<table border="0"
cellspacing="0" cellpadding="3" height="31">
<tr>
<td align="right"
valign="middle"><select name="var" size="1">
<option
value="A">A</option>
<option
value="B">B</option>
<option
value="C">C</option>
<option
value="E">E</option>
<option
value="F">F</option>
<option
value="G">G</option>
<option
value="H">H</option>
<option
value="I">I</option>
<option
value="J">J</option>
<option
value="K">K</option>
<option
value="L">L</option>
<option
value="M">M</option>
<option
value="N">N</option>
<option
value="O">O</option>
<option
value="P">P</option>
<option
value="Q">Q</option>
<option
value="R">R</option>
<option
value="S">S</option>
<option
value="T">T</option>
<option
value="U">U</option>
<option
value="V">V</option>
<option
value="W">W</option>
<option
value="X">X</option>
<option
value="Y">Y</option>
<option
value="Z">Z</option>
</select></td>
<td
valign="middle"><input type="image" src="img/input.jpg" alt=""></td>
</tr>
</table>
</div>
</form>
Here's the code from the secondary page:
$var = floor($_GET['var']);
mysql_connect('x', 'x', 'x');
mysql_select_db('x');
$query = "SELECT *
FROM shows
ORDER BY sorttitle
WHERE begins = '$var'";
What's going on?!
