Re: [drewh01] Setting up a search page with search block and Pre-configured searches
Hi Drew,
Here's one of the recipes from my CMSB Cookbook
thecmsbcookbook.com regarding setting up searches. It may be of help in getting you started.
Jerry Kornbluth
SEARCH FORM THAT GETS LABEL VALUES FROM A LIST FIELDInstead 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
The first CMS Builder reference book is now available on-line!
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php