This topic is locked

Advanced Search: Multiple terms in one search field

1/5/2008 12:52:27 PM
PHPRunner General questions
G
glennb author

I'm a new user, and very impressed. Novice php/mysql skills, but learning. For the past two days, I've scoured fairly fully the forum and help files, but not finding the help I need.
I manage an online academic bibliographic database (here's the current site: http://comppile.tamucc.edu), using a "webdata pro" dbms (perl-based) and proprietary. I want to move the dbms to php, especially the search/results feature, and finally found phprunner.
The one search functionality that I am missing (and one I "think" users will miss, too), is the ability to submit boolean searches in a field (such as searching for authorA and authorB (as coauthors). My db (93000 records and growing daily) structure puts all author information in one field (author).
I have a search form using phpRunner here: http://teach4learning.org/compuser
Any clues about how to enable multiple items in one search field? Is that a feature in the beta (which I haven't downloaded)?
Glenn

J
Jane 1/9/2008

Glenn,
you can do the following:

  1. edit your SQL query on the Edit SQL query tab.

    Here is a sample:
    select author,

    author as author2,

    ...

    from TableName


2. check author2 field on the advanced search page only on the Choose fields tab and rename label for this field to co-author.