2. PHPRunner General questions
  3. need to filter records based on calendar date
This topic is locked

need to filter records based on calendar date

 		1/4/2008 9:42:32 AM
PHPRunner General questions
F
 frocco author

Hello,
I want to replace the search window on the left side of the table to show a calendar.

Whe the user clicks on the calendar, only the records of that day are shown.
How can I do this?
Thanks
Frank
J
 		Jane 1/9/2008

Frank,
you can do it using custom event (Insert PHP code snippet option) on the Visual Editor tab.

Here is a sample:

global $conn;

$str = "";

$str.= "<table><tr><td>";

$str.= "<a href=\"tablename_list.php?a=search&value=1&SearchFor=2008-01-09&SearchOption=Contains&SearchField=DateField\">9 January</a>";

$str.= "</td></tr></table>";



where DatField is your actual field name.