rendered paste body<form action="main.php" method="post">
<select name="rlsdate">
<option value=""selected="selected">Released</option>
<option value="3ormore">in the last 30 days</option>
<option value="2ormore">in the last 60 days</option>
<option value="1ormore">in the last 90 days</option>
<option value="1ormore">in the last 6 months</option>
<option value="1ormore">in the last year</option>
<option value="1ormore">over a year ago</option>
</select>
<select name="avgrating">
<option value="" selected="selected">Avg.Rating</option>
<option value="4ormore">> 4 </option>
<option value="3ormore">> 3 </option>
<option value="2ormore">> 2 </option>
<option value="1ormore">> 1 </option>
</select>
<select name="genre">
<option value="" selected="selected">Genre</option>
<option value="action">Action</option>
<option value="animation">Animation</option>
<option value="kids">Childrens</option>
<option value="comedy">Comedy</option>
<option value="docu">Documentary</option>
<option value="drama">Drama</option>
<option value="horror">Horror</option>
<option value="musical">Musical</option>
<option value="scifi">Science-Fiction</option>
<option value="thriller">Thriller</option>
</select>
<input type="submit" value="Apply Filter" />
</form>
<?php
$rlsdate = $_POST["rlsdate"];
$avgrating = $_POST["avgrating"];
$genre = $_POST["genre"];
$sqlQuery = "SELECT * FROM dvd_titles, critics_rating, dvd_genres WHERE dvd_rlsdate=\"$rlsdate\" AND rounded_rating=\"$avgrating\" AND dvd_genre=\"$genre\"";
?>