Select all in dropdown

[caspar007]

I am trying to do a search where the user has a selection of list boxes. I want them to be able to search All Types in the list box.

EG: <select name="type">
<option value="">All types
<option value="Campervans">Campervans
<option value="Motorhomes">Motorhomes
<option value="5th Wheelers">5th Wheelers
</select>

What do I use as the option value for All Types so that when the list box passes the value to the results page in the URL it lets the sql query know that it is to select *

Thanks

[LordShryku]

Whatever you want really. Then on the next page, just use a conditional.

Say you did option value="ALL"

if(isset($_POST['type'])) {
   if($_POST['type'] == "ALL") {
      $selectMe = "*";
   }
   else {
      $selectMe = $_POST['type'];
   }

   $sql = "SELECT ".$selectMe." FROM table";
}