on Sun, 22 Sep 2002 17:06:01 GMT, Mariusz wrote:
> I have a "discount" table that carries percentage discounts that
> should be looked up when the customer submits a discount code and
> taken into calculation of the total price. My table looks something
> like this:
>
> field names:|senior|
From: "Tanton Gibbs" <[EMAIL PROTECTED]>
To: "Mariusz" <[EMAIL PROTECTED]>; "perl" <[EMAIL PROTECTED]>
Sent: Sunday, September 22, 2002 1:07 PM
Subject: Re: MySql - Perl question
> Often times, a separate table of valid choices exists in the data
Often times, a separate table of valid choices exists in the database which
you can quickly search first. Usually, you would select everthing from the
table at startup time and put it in a hash, then when you need to process
the query, first lookup the users entry in the hash of choices. If it i