Foren / Cotonti / Support / PHP MySQL Date Range Search

Kaan
#1 7. Februar 2020, 08:07

 

I want to search pages between two dates

Dayver
#2 17. Februar 2020, 20:39
SELECT * FROM cot_pages WHERE page_date > 1581971825 AND page_date < 1580589422

 

Pavlo Tkachenko aka Dayver
Kaan
#3 16. März 2020, 10:50

@dayver thanks

page_date BETWEEN '".strtotime($page_date)."' AND '".strtotime($page_date)."' solved the problem