So this is what I have now:
Quote:
|
$result = mysqli_query($con,"SELECT * FROM CookingShows WHERE ShowDate (date as DATE) BETWEEN CAST('2022-09-01' AS DATE) AND CAST('2022-10-01' AS DATE)");
|
It still doesnt show me any data.
The column is set to varchar(255) if that makes any difference? It isnt set as date, datetime, or anything like that, should it be?