// lol // Request mode: qsearch (side panel search) if ($_REQUEST['mode'] == 'qsearch') { if ($_POST) { // Build query string based on user's input if (isset($_POST['lastname'])) { $lastname = $_POST['lastname']; $lastnameSQL = "AND last_name LIKE '%$lastname%'"; } else { $lastnameSQL = ""; } if (isset($_POST['ext'])) { $ext = $_POST['ext']; $extSQL = "AND ext LIKE '%$ext%'"; } else { $extSQL = ""; } if (isset($_POST['section'])) { $dept = $_POST['section']; $deptSQL = "AND dept LIKE '%$dept%'"; } else { $deptSQL = ""; } $query = "SELECT * FROM staff WHERE 1=1 $lastnameSQL $extSQL $deptSQL"; $result = $db->query($query); } }