php - Why is this not selecting only records with a date older than 7 days? -


I am trying to filter for the row with the value of '1' in the active column and where the last phloemmail_date date The column is 7 days or more than the current date.

Many sites are being searched on the Internet, this is the query that I have come up with but for some reason it is not filtering properly (query is less than 7 days from the current time Is selecting record over time).

Why this might be so, but any thoughts will be very much appreciated and appreciated. Thanks so much in advance! e_sales_prospects from SELECT * where activate = '1' and the last fallowmail_date & gt; (I You want the lines that are older to be seven days, in that case you want the rows small , then in my opinion it should be

  lastfollowupemail_date & Lt; DATE_SUB (NOW (), INTERVAL 7 DAY)    

Comments

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -