ideas on db and code creation
Posted: Wed Jun 13, 2007 10:39 am
I'm creating a select menu where 2 of the <options> rely on on eachother to determine the overall.
Example:
option 1. = Select quantity (500, 1000, 1500, 2000, etc to 10000)
option 2. = Select paper type (80# gloss text, 80# matte text, 80# gloss cover, 100# gloss text, 100# matte text)
While this wouldve been simple to just call the individual price of the paper type, and multiply that by quantity, that isnt how it can go
(of course) lol.
In the real-world they want it so that if someone orders 500 , the price is more than say 10,000 pieces.
and so therein lies the issue.
Any suggestions on what the more seasoned php / mySql would do in this scenario?
I have a few ideas but it feels like chasing squirrels with one shoe on. (dunno why it feels like that , but thats what my thought told me)
So anyway , I'd like to set out in a good direction with confidence it will work.
Any suggestions?
thank ya's
Example:
option 1. = Select quantity (500, 1000, 1500, 2000, etc to 10000)
option 2. = Select paper type (80# gloss text, 80# matte text, 80# gloss cover, 100# gloss text, 100# matte text)
While this wouldve been simple to just call the individual price of the paper type, and multiply that by quantity, that isnt how it can go
(of course) lol.
In the real-world they want it so that if someone orders 500 , the price is more than say 10,000 pieces.
and so therein lies the issue.
Any suggestions on what the more seasoned php / mySql would do in this scenario?
I have a few ideas but it feels like chasing squirrels with one shoe on. (dunno why it feels like that , but thats what my thought told me)
So anyway , I'd like to set out in a good direction with confidence it will work.
Any suggestions?
thank ya's