2. PHPRunner General questions
  3. [SOLVED]  Don't show records with empty date field
This topic is locked
[SOLVED]

 Don't show records with empty date field

 		4/15/2015 3:23:20 AM
PHPRunner General questions
S
 shoppy author

Hi all,
I wish the records that have an empty date field not to show on the listpage.

Can anyone tell me how to do that?
I still use PHPRunner 4.3
Thanks in advance.
John
Sergey Kornilov admin 4/15/2015

Modify SQL Query adding a WHERE clause like this:

SELECT * FROM tablename WHERE DateField IS NOT NULL
S
 		shoppy author 4/16/2015



Modify SQL Query adding a WHERE clause like this:

SELECT * FROM tablename WHERE DateField IS NOT NULL



Thanks a lot Sergey