2. PHPRunner General questions
  3. CURRENT DATE
This topic is locked

CURRENT DATE

 		12/14/2005 13:55:06
PHPRunner General questions
D
 defcon2000 author

Hello,
I have a reminder database and would like to search from the address bar based on todays date.
The field I have is called reminderdate which is of date type.
On the basic search type, I select "reminderdate", then" <=" and then I tried putting in "CURDATE()" and also I tried putting in "NOW()" but neither work. How can I implement this?
Also how can I do 2 searches on the address bar with e.g. the above quesry together with say reminderstatus = "Open"?
Thanks in advance.
Rgds,
Sergey Kornilov admin 12/15/2005

Hi,
to perform a search based on current date you should enter 12/15/2005 in the "Seacrh for" box.

No functions are supported there.
You can use Advanced search if you need to specify complex search conditions.

If you want to get the URL for advanced search please modify ..._search.php file.

Replace

<form method="POST" ...

with

<form .. method="GET" ...



Then perform a search and you'll see the URL in the Address box.
D
 		defcon2000 author 12/15/2005

Thank you. It works I can see the header.
But now, I can't use in the advanced search anything such as CURDATE(), NOW() or something?
How can I make a search for where "reminderdate <= currentdate" without having to put in the date manually?
Thanks in advance.
Sergey Kornilov admin 12/15/2005

Hi,
PHPRunner doesn't support these types of searching.
You can modify PHPRunner created pages manually to implement functionality you need.

However this task requires custom programming.