Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Omit records by end date

New Here ,
Dec 09, 2012 Dec 09, 2012

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?

TOPICS
Server side applications

Views

876
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 11, 2012 Dec 11, 2012

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines