$query ="SELECT *
FROM expiration
where 'expirationdate' BETWEEN (DATE_FORMAT(curdate(),'%m/%d/%Y')) AND (DATE_FORMAT(curdate()+ INTERVAL 6 MONTH,'%m/%d/%Y'))";
where is the problem
Asked
Active
Viewed 34 times
-1
Sammitch
- 30,782
- 7
- 50
- 77
-
remove the date format that os no date format for mysql – nbk Apr 21 '22 at 21:21
-
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – Community Apr 21 '22 at 23:29
1 Answers
1
Column names must be in Backticks see When to use single quotes, double quotes, and backticks in MySQL and as mentioned don't convert the date column
$query ="SELECT *
FROM expiration
where `expirationdate` BETWEEN curdate() AND curdate() + INTERVAL 6 MONTH";
nbk
- 45,398
- 8
- 30
- 47
-
thank you sooooooooooooo much i have been for 1 day look for a solution finally it works <3 – Mahmoud MJ Apr 21 '22 at 21:32