Absolute newbie trying to code. I'm trying to search my database based on a number of criteria where the user has selected from drop-down menus.
To try to get it working I've cut the code back to searching for one criterion (difficulty) but I've realised I don't know where to send it! I'd like to put "search.php" or similar after "action = " but the file doesn't exist and I don't know how to create it.
Any help appreciated!
Draft code below:
<form method="post" action="">
<option value="" selected="selected">-any-</option>
<option value="Very Hard">Very Hard</option>
<input type="submit" value="search">
$result = MySQL_query("SELECT * from Attributes WHERE Difficulty == '%$difficulty'