I am fairly new to sql and am now getting into the area of slightly more complex queries.
At present my query is $query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' ORDER BY fname $type"; but I have two other filters which may or may not be chosen. (area, and interest). $query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND area='area' AND interest='interest' ORDER BY fname $type"; but what if nether is chosen, or only one? Is there an AND/OR operator or similar in mysql? Thanks, Ross