I have found similar answers but I didn't find exact one, so I am starting a new question.
I have a little app for a mechanic shop, where the user can input information about the car, such as registration number, a name of the owner, date when the car was on service ( an auto added/updated field in MySQL).
My question is since all cars must do a service inspection again in 6 months, how can I after 5 months print out information that in next 30 days XY cars needs to make a new inspection?
EDIT:
*SELECT * FROM vozila where DATE_ADD(DATE(datum), INTERVAL 6 MONTH) = CURDATE()*
In case above, it is displaying only 5-month-old serviced cars from current date, but I need to set it to display notification 5 months after, and that that results stay on page for next 30 days (untill month 6th).
Let's say that some XY car was on the mechanic service at 1.1.2017... At 1.6.2017 on notification.php page there would be "Cars with expiration date in next 1 month:" table and on it would be all cars that are 1 month left up to 6th when then need to do it again.