This topic is locked

Dynamic advanced search

2/7/2008 6:08:33 PM
PHPRunner General questions
F
Fawaz author

In the advanced search page: How do I make dynamic queries?
For example, I have a field called 'due' and I want to make search on all orders that are due between now and now + 1 hour?
How do I define "now()" in advanced search page?

Thanks.

Fawaz

J
Jane 2/8/2008

Fawaz,
use following code in the Search page: before siplay event on the Events tab for this purpose:

$smarty->assign("value_FieldName",now());



where FieldName si your actual field name.

F
Fawaz author 2/8/2008

Jane,

How do I add one hour to the previous code?
Something like this:
$smarty->assign("value_FieldName",now()+ 1 HOUR);
Thanks.

Fawaz