Newbies machead Posted April 22, 2005 Newbies Posted April 22, 2005 I'm trying to limit search results to only those whos dates are today or in the future. I created a flag field named current with a value of 1 to indicate those records which meet this criteria. I am doing a "google" style search where I pass the users search term into multiple fields, which works nicely, except for the AND and OR logic mix. Here's a sample of the PHP - <?php $search=new FX ($serverIP,$webCompanionPort); $search->SetDBData('wkspweb.fp5','web'); $search->AddDBParam('current','1'); $search->AddDBParam('-lop','and'); $search->AddDBParam('description',$search_term); $search->AddDBParam('-lop','or'); $search->AddDBParam('wksp_title',$search_term); $search->AddDBParam('-lop','or'); $search->AddDBParam('presenter_first',$search_term); $search->AddDBParam('-lop','or'); $search->AddDBParam('presenter_last',$search_term); $searchResult=$search->FMFind(); ?> Is it possible to nest these queries somehow, or filter the results to exclude older events?
Recommended Posts
This topic is 7224 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now