I'm trying to make notification when msql column reach a certain number.
For exemple, I have table "items" with products, witch in their structure have columns id, name and quantity, and when column "quantity" reached 5, I want to make automatic notification:
- In new table called "notifications" witch will also have id, name and quantity but just with products from table "items" that have number 5 or less.
- Or somehow to make php table that will display products from the table "items" with a quantity less than 5.
Is is possible?
Thank you in advance.