jQuery Forum

It depends on the code that executes the query.

The most basic would be to have all of the search options inside a form and send all of the fields to the page that runs the query so that you'll modify the SQL to retrieve the information:

1. <form action="searchPerson.php">
2.       <input type="text" name="name" />
3.       <input type="text" name="age" />
   
4. </form>
   

1. // if $age is not empty then $sql_age = " and age = '$age' "
2. $sql = "select * from person where name = '$name' $sql_age"
   

Now, if you're using AJAX you'd only have to modify the url being called to include the other search fields, and then treat them on the page that actually runs the query.

1. $.ajax({
       type: "POST",
       url: "search.php",
       data: "name=John&age=",
       cache: false,
       success: function(html){
           $("#results").append(html);
       }
   });
   

You can add as many search fields as you want as long as you find a way to pass them as parameters to the query. Be sure to check if your dynamic queries are well formed after you include variables which may be empty or filled with values that'll cause the execution not to go through. Testing all of the variables is a good way to prevent it.

Thank you so much for the detailed answer!