2. PHPRunner General questions
  3. Hide past dates...
This topic is locked

Hide past dates...

 		7/5/2008 6:21:26 AM
PHPRunner General questions
T
 Tom16 author

Hi,
I want to be able to hide past dates in the view. In this case dates of events that lie in the past. Is there an easy solution?
Any ideas...?
Tom
Sergey Kornilov admin 7/5/2008

Add WHERE clause to your SQL query i.e.

select ... from ... where DateField>Now()
T
 		Tom16 author 7/7/2008

Add WHERE clause to your SQL query i.e.

select ... from ... where DateField>Now()


Sorry Sergey,
My table is events and date field is Begindatum. How do I fit them into the query?
Tom (thanks for helping...)
J
 		Jane 7/8/2008

To,
here is a sample:

select ...

from ...

where Begindatum>Now()