Copy link to clipboard
Copied
I have a website were records from mySQL are bound to the page. In the database i have an end date for each record and I want to omit records when the end date comes round. I have tried different methods to no avail. Can anyone help?
Copy link to clipboard
Copied
I assume your query looks a little like this:
SELECT *
FROM datatable
you need to tell your query to only select records with an 'end-date' after the current date, something like this:
SELECT *
FROM datatable
WHERE end–date > CURDATE()
Hope this helps
Louie