Why does this not work in PHP?
$dato = '2018-12-31';
$sql = "SELECT sort_date, form FROM wp_booking WHERE date(sort_date) = $dato";
Best regards kresten
Asked
Active
Viewed 18 times
0
Funk Forty Niner
- 74,450
- 15
- 68
- 141
Kresten
- 810
- 13
- 36
-
Your question not clear – ttrasn Dec 26 '18 at 16:10
-
to put simple just change sql statement to $sql = "SELECT sort_date, form FROM wp_booking WHERE date(sort_date) = '$dato' "; as you need quotes around $dato to insure database can read where statement – ForgivenIT Dec 26 '18 at 16:15