3 Replies Latest reply: Jan 31, 2009 11:09 PM by DwFAQ RSS

    Help with MySQL Form Search

    Mike_Watt Community Member
      I've got a db that contains various attributes of particular items... very similar to a db of a DVD library, for example... Director, Year of Release, comments, release date... etc.

      How do I structure the query in Dreamweaver (CS3) to tell the db to return ALL results for a field if it is submitted blank? As in, if a user didn't specify a Director, then it should not filter by that column and return ALL directors instead?

      In the advanced recordset dialogue I have the variables set to submit the run-time values from the form, but I don't know what to put in the "Default Value" field...

      I know this should be very simple, but I just can't get it to work... I tried %, but that's not doing it. (also, I tried searching the forum, but the search function is not working properly right now.)

      Any help is appreciated.