Member Avatar for logicaweb

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
  • 141 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by IIM
Member Avatar for IIM

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.

Member Avatar for logicaweb

I made it using triggers. Thank you.

Member Avatar for IIM

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.