0

Hello,

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.

2
Contributors
3
Replies
21
Views
4 Years
Discussion Span
Last Post by IIM
1

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.