Jump to content


Photo

Little help here


  • Please log in to reply
3 replies to this topic

#1 tobeyt23

tobeyt23
  • Members
  • PipPipPip
  • Advanced Member
  • 259 posts
  • LocationSalisbury

Posted 30 October 2006 - 02:27 PM

I would like to design a database table to query against qtys to get pricing. Would this work or am I not seeing an easier way:

table:
min
max
cost



#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 30 October 2006 - 02:29 PM

You'll need to be clearer in your description of what it is you want to do.

#3 tobeyt23

tobeyt23
  • Members
  • PipPipPip
  • Advanced Member
  • 259 posts
  • LocationSalisbury

Posted 30 October 2006 - 02:33 PM

Sorry, When a user selects an item to buy and wants 20-50 I would like to query the table to get a cost. So if they buy 100 the cost will be different.

#4 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 30 October 2006 - 03:05 PM

So a bulk-buying discount.

Are the products going to be discounted as a % of the original cost?

Regards
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users