Re: MySql - Perl question

2002-09-23 Thread Felix Geerinckx
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|

Re: MySql - Perl question

2002-09-22 Thread Mariusz
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

Re: MySql - Perl question

2002-09-22 Thread Tanton Gibbs
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