I am just starting to learn DBMan so I can add a public search function for a pre-existing database.
I am currently using a query like:
http://mydomain.com/cgi-bin/db.cgi?db=default&keyword=kayak&view_records=View+Records which works great, except that I need to only return results which have status=active (field 2 in the db is named status, and sites are either active or inactive. I don't want the inactive sites showing up in the search results as these have not been validated yet.)
How can this be done?
P.S. I am searching by keywords because I need to search the Title, Description, and URL fields from one public search form field. Thanks.
I am currently using a query like:
http://mydomain.com/cgi-bin/db.cgi?db=default&keyword=kayak&view_records=View+Records which works great, except that I need to only return results which have status=active (field 2 in the db is named status, and sites are either active or inactive. I don't want the inactive sites showing up in the search results as these have not been validated yet.)
How can this be done?
P.S. I am searching by keywords because I need to search the Title, Description, and URL fields from one public search form field. Thanks.
how to search for keywords, only if field2=active?