[FX.php List] Search for records by date range

Kim Hawksworth hawksworth-2 at medctr.osu.edu
Tue Sep 21 06:52:52 MDT 2004


I have a database that I would like to be able to search by date range. 
  I have a field in the database called "date" which auto-enters the
record's creation date.   Under CDML I used the following code in an
html form to search records by date range:

>From Date: <input type="hidden" name="-op" value="gte"><input
type="text" name="date" value="">
To Date: <input type="hidden" name="-op" value="lte"><input type="text"
name="date" value="">

Is there an easy way to do this with FX.php?  If I use this same code
with FX.php, it only returns records with the "To Date".

 

Kim David Hawksworth, R.Ph., Web Manager
The Ohio State University Medical Center
Department of Pharmacy


More information about the FX.php_List mailing list