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.

yes it is possible.Before inserting check if size is less than 4.If it is 4 and you are inserting record then you can add notification from your php page.
Another way is using trigger on insert.After inserting check the size and call any procedure once count reaches 5.

I made it using triggers. Thank you.

please mark the thread as solved if your problem is solved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.