SEARCH FORM THAT GETS LABEL VALUES FROM A LIST FIELD - Aug 17th, 2011

Instead of manually entering your search criteria, you can use this code to retrieve the label values from a list field and automatically insert them into your search form. Possible values for your-criteria are listed below. <form method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>"> <select name = "your_field_your-criteria" > <option value="">Please Choose a Category</option> <?php foreach (getListOptions('your_table ', 'your_field') as $value => $label): ?> <option value = "<?php echo $value;?>" <?php selectedIf($value, @$_REQUEST['your_field']);?>> <?php echo $label; ?></option> <?php endforeach ?> </select> <input type="submit" name="submit" value="Search" > </form> __ Search Criteria (your-criteria) _match - an exact match _keyword - will look for specific words _prefix - starts with keyword (or letter) _query - allows google-style query searches such as: +dog -cat "multi word phrase". Only records matching EVERY word or quoted phrase are returned. Words or phrases that start with - mean "must not match". The + is optional and not required. _fieldname_empty Matches blank fields Matches fields that are blank (""). Example: email_empty=1 _min - A minimum value for numeric searches _max - A maximum value for numeric searches _year year number for date searches _month - month number for date searches _day - Day of month for date searches

Terms of Service