Sql Select code not working

Hi Guys

I am trying to select mysql data that is between two days in the past to 3 days in the future but I am having issue even to get any output from the codes I have found this is what I have so far it still doesn’t work

$result = mysqli_query($con,“SELECT * FROM Despatch WHERE Branch = ‘B’ AND Despatch_Date BETWEEN NOW() and NOW(), INTERVAL 7 DAY ORDER BY Despatch_Date ASC”);

Any help would be great I have been trying to work out how to do it for afew days now

Lateral Logic…
Add 3 days to the current time then you look backwards through the table over seven days


looks about right but I’m still on the first coffee of the morning

Hi Thanks for the help am new to the mysql so its a little confusing so I need to put my code like this I been looking online but can’t seem to get my head around it

$result = mysqli_query($con,"SELECT * FROM Despatch,DATE_SUB(DATE_ADD(CURDATE,INTERVAL 3 DAY)),INTERVAL 7 DAY) > ORDER BY Despatch_Date ASC AND WHERE Branch = ‘B’ ");