194 reputation
19
bio website
location
age
visits member for 3 years
seen Nov 13 at 16:43

Nov
13
awarded  Notable Question
Jul
2
awarded  Curious
Jun
2
awarded  Popular Question
Nov
9
awarded  Popular Question
Sep
27
awarded  Popular Question
Aug
25
asked Dynamic form from a database
Oct
6
accepted How to store formula method in the table
Oct
3
comment How to store formula method in the table
Yes @grid :) Basically something like Admin click on the formulas setting page on the website and create a formula (Choose Minus, Plus, Fields) and save it. Then go to any category and select a formula from a dropdown to apply. Do you get the idea?
Oct
3
comment How to store formula method in the table
@grid There is no need to use eval() function but something like that yes. Basically on the Admin site, admin select the formula setting on the site.
Oct
3
revised How to store formula method in the table
added 205 characters in body
Oct
3
comment How to store formula method in the table
For example Admin on the websute can select a formula setting on each category and save it. The formula setting could be saved in category_formula table but how the table should be designed.
Oct
3
comment How to store formula method in the table
Thanks for the answer. Is there alternative way to keep a list of formula records in a category_formula table for example? I am not sure what fields do I need but you could answer that. I would use PHP to calculate the sum.
Oct
3
comment How to store formula method in the table
categories will be subject to change however I should be able to apply same formula to many categories if I wanted to. If the formula change - I would create a new formula record and then update on existing categories records.
Oct
3
revised How to store formula method in the table
added 4 characters in body
Oct
3
asked How to store formula method in the table
Sep
17
revised Mobile Phone & Tariffs
added 6 characters in body
Sep
17
revised Mobile Phone & Tariffs
added 377 characters in body
Sep
17
comment Mobile Phone & Tariffs
Description part into columns is a good idea and I will look into that. My question was is the relationship design between phone, tarrif, network and saleType is ok? I assume you understood from my tables design? Basically operator can select a retailer which then select Mobile Network.. then select what type of sale (eg: consumer upgrade) and then select phone with related related tariffs. Depending what tarrifs and/or phone they have selected - operator gets number of points.
Sep
17
asked Mobile Phone & Tariffs
Mar
6
asked Database Design - Employee Clocking In and Out System