I have a condition in PHP that checks if a user select an airport from a drop down menu , the results should be entries that matches that airport, but i want to amend it so that if a user selects, All London Airports, it should yield entries fro london stansted, london gatwick, london city and heathrow. I managed to get it to work with one condition but not sure how to get it to work with many entries. The code below works but can you advise how to amend it to include other london airports.
Code: Select all
$sql .= ' AND departurepoint= ("London Gatwick")'; }
else {
$sql .= ' AND departurepoint = "'.$depoint.'"'; }
.
[/syntax]
Note: $depoint is the variable that stores users selection
Departurepoint is the column name in the table
Thanks in advance