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
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’ ");