sam123 Posted November 20, 2012 Share Posted November 20, 2012 Hi, I am having a problem that I was hoping someone here would be able to assist me with. Basically its for an online shop. Some of the products have special offers on them when the number of customer reach up to a perticaulal number.I have two tables in my database. One to hold the information about the product, and one to hold the information about user price quote table. 1.Product table(retailer table) price | no.of customers | Offer1 |no.of custmers | offer2 $200 | 10 | $100 | 5 | $90 2.Quote(User table) Price | High | Low $200 | $400 | $80 The number of users who have registered for a product reaches the number limit set by the retailer, i.e. 10, then the new offer is $100, i need to sent out this new offer to the users. I have to get the count of customers whos price range of the product is equal to the product price in the product table.Then i need to comapre this count to no.of customers and if it matches i need to set the offer. Any help would be appreciated. Thank you. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.