Skip to main content
B
bones_knight
Participant
December 9, 2012
Question

Omit records by end date

  • December 9, 2012
  • 1 reply
  • 907 views

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?

This topic has been closed for replies.

1 reply

LouieCypher
LouieCypher
Known Participant
December 11, 2012

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices