Reputation: 34 Craftsman
- Members w/DIC++
- Active Posts:
- 679 (0.32 per day)
- 24-July 08
- Profile Views:
- Last Active:
- Mar 06 2013 01:03 PM
- OS Preference:
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Dream Kudos:
Posts I've Made
Posted 2 Mar 2013In the way I just explained if I add a new variable I have to add new columns.
Can you explain how my option is "not effective"?
Maybe I'm not explaining myself very well the idea of this is so the owner can set certain discount criteria e.g. Give £10 discount when the number of nights is greater than 2... Give £20 discount when the number of people is less than 4.... Give £30 discount when the the booking is made equal to 10 days before etc...
I very much appreciate your feedback modi... This is exactly the reason I started this post to get other people's opinion and positive critism
Posted 2 Mar 2013It's very restrictive that's the only thing what if I were to add a new variable e.g. The "the booking was made" to the first column.
I was thinking something more like
Variable | Expression | Condition | Condition End
The variable being "length of stay" or "number of people" etc.
Expression being "greater than" or "less than" etc.
Condition being 1 or 2 etc
Condition End used when the expression is between.
What do you think?
Posted 2 Mar 2013Okay thanks modi and how would you store the less than, greater than etc.. Variables?
Posted 2 Mar 2013Hi modi,
Store the form values in the database. The form is to allow the admin to set the criteria that the booking has to qualify for to receive the discount.
It will probably end up being more complex but I just wanted to get ideas to how others would store this in the database with a simplified version.
- Member Title:
- D.I.C Addict
- 23 years old
- June 8, 1990
- Big fan of Rugby and obviously Programming as i wouldn't be here otherwise :)
- Years Programming:
- Programming Languages:
- HTML, CSS, PHP/MySQL, VB.NET, MSSQL and Jquery
- Website URL: