I am trying to build a search form that will invlove a complex query for two separate terms....to give an example of what i mean....
e.g.
I have a form that searchs a daabase or 2 bits of inoformation
form - input phrase
and
form - input year - input month - input day
the form allows the user to search by string term or by supplying a date.
now my table is made up
table - index full text (title, description)
table - field date(yy mm dd)
so the form searchs the tables index if the query is for the phrase and the date field if the query is for the date. Now the scenario is
the search script should be able to search for either a string or date or both
for the date string the user may enter only a year or a month or a day or a combination of the 3
In trying to build the script i realise that it may be a wise thing to do 2 separate searchs i.e mysql_query(search for string,$connection) then mysql_query(search for date,$connection) and then combine the results of both for display.
my question is?
This question is more of a matter for advice...your input is greatly appreciated.In methods of building complex search forms and scripts is my theory correct? or can this be doen with on simple query with the database i.e. mysql_query(search for string or date,$connection)
Kendall