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