I want to create 2 search boxes:
<INPUT TYPE="text" NAME="day" VALUE="01">
<INPUT TYPE="text" NAME="month" VALUE="Mar">
and then have them combine to create the following search:
http://www.mysite.com/...01-Mar&Year=2005
the field Date is in the format 01-Mar, 02-Mar etc.
Most records in the database have several Dates spreading over several months.
Is there anyway of doing this using a global? and how would I write the search form to call the global.
Ideally I would have liked to have separate day & month fields in the database but this would not work because if an event was being held on both 28 Feb 2005 and 01 Mar 2005 then
http://www.mysite.com/cgi-bin/search.cgi?day=01&month=Mar&Year=2005 would produce results that showed the event was occurring on 01 Feb 2005 when it wasn't.
Thanks.
<INPUT TYPE="text" NAME="day" VALUE="01">
<INPUT TYPE="text" NAME="month" VALUE="Mar">
and then have them combine to create the following search:
http://www.mysite.com/...01-Mar&Year=2005
the field Date is in the format 01-Mar, 02-Mar etc.
Most records in the database have several Dates spreading over several months.
Is there anyway of doing this using a global? and how would I write the search form to call the global.
Ideally I would have liked to have separate day & month fields in the database but this would not work because if an event was being held on both 28 Feb 2005 and 01 Mar 2005 then
http://www.mysite.com/cgi-bin/search.cgi?day=01&month=Mar&Year=2005 would produce results that showed the event was occurring on 01 Feb 2005 when it wasn't.
Thanks.