May I conclude from your question ("What will be the query?") that you already have the drop-down and the textbox? If so, the table query can be defined as something like (search items in $search1 and $search2):
- $sql = 'SELECT Id, Name ';
-
$sql .= 'FROM MyTable ';
-
$sql .= 'WHERE Name REGEXP "' . $search1 . '" ';
-
$sql .= 'AND Id REGEXP "' . $search2 . '" ';
-
$sql .= 'ORDER BY Id';
Ronald :cool: