Null fields

[danjoe_15]

I have a form in which users can type in a value into a text box(there are bout 20 different text boxes) and I return the records matching the search criteria.  I am able to get this to work if all of the text boxes are filled in however I do not know how to check if a variable is null and if it is then to ignore that text box and not search for " " in that field.

[fenway]

If you're talking about getting values from an html form, you're asking in the wrong place.

[danjoe_15]

Yes the values come from an html form, however I use a mysql query to take those values and use them in a where clause.

[danjoe_15]

Here is an example of what I am trying to do.  With this code I could find say anyone from the state of Califorina with the last name of smith.

 

<code>

$c = dbQuery("SELECT * FROM customers WHERE last_name= %1 AND states=%2", $_POST['LastName'], $_POST['State']);

$customer = mysql_fetch_assoc($results[$c]);

</code>

 

However I am lost as to how to rewrite this to search for say anyone with the last name of Smith, or anyone from the state of California.

[fenway]

Understood -- well, first you need to determine which fields have been filled out, and then build your query -- not the other way 'round.