user added time variance

[johnberman]

Hi

I have the following query in my database

SELECT
a.event_id,
a.user_ID,
a.date,
a.Time
FROM quadrantids2017 AS a
JOIN quadrantids2017 AS b
WHERE a.date = b.date

AND time_to_sec(a.Time) - time_to_sec(b.Time) BETWEEN -30 AND 30

which works fine and brings back what I want.

Using PHPMaker I some how want to

remove this from my query
AND time_to_sec(a.Time) - time_to_sec(b.Time) BETWEEN -30 AND 30

and simply let the user enter a time variance so they could enter 2 or 3 etc

On this one Im just not sure where to start

Regards
John B

[mobhar]

Try "Recordset_Selecting" and/or "Recordset_Searching" server event to define your custom filter criteria based on your needs.

Please read "Server Events and Client Scripts" topic from PHPMaker Help menu for more info and example.