Jump to content

Help with Mysql and PHP


Matthew Payton
 Share

Recommended Posts

Hi there, hopefully someone can help me

I'm trying to pull the results from mysql table where anything between 6 days and 11 days old from the current date. 

Here is my code below but I think I 'm way off...

"SELECT * FROM sent_msg WHERE line_status='2' AND collection_arranged='No' AND service_type='SWAPIT - Delayed' AND ship_date BETWEEN ship_date > current_date - INTERVAL 6 DAY AND ship_date < current_date - INTERVAL 11 DAY";

 

If anyone can help that would be amazing... the key is 

It only shows results for anything between date1 and date 2 and it will be 6 days from today to 11 days from today I need it to show. 

 

Hope this makes sense.

Edited by Matthew Payton
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...