Hi This is the query that i run
select ,
(quant1 unit1) as mycost1,
(quant2 unit2) as mycost2,
(quant3 unit3) as mycost3,
(quant4 unit4) as mycost4,
(quant5 unit5) as mycost5,
(quant6 unit6) as mycost6,
(quant7 unit7) as mycost7,
(quant8 unit8) as mycost8,
(quant9 unit9) as mycost9,
(quant10 unit10) as mycost10,
((quant1 unit1) + (quant2 unit2) + (quant3 unit3) + (quant4 unit4) + (quant5 unit5) + (quant6 unit6) + (quant7 unit7) + (quant8 unit8) + (quant9 unit9) + (quant10 unit10) + delivery) 0.175 as mvyat,
((quant1 unit1) + (quant2 unit2) + (quant3 unit3) + (quant4 unit4) + (quant5 unit5) + (quant6 unit6) + (quant7 unit7) + (quant8 unit8) + (quant9 unit9) + (quant10 unit10) + delivery ) 1.175 as mytotal
From `orderform`
Is it possible to have a check box on the edit and add pages that will make it us the following query:
select ,
(quant1 unit1) as mycost1,
(quant2 unit2) as mycost2,
(quant3 unit3) as mycost3,
(quant4 unit4) as mycost4,
(quant5 unit5) as mycost5,
(quant6 unit6) as mycost6,
(quant7 unit7) as mycost7,
(quant8 unit8) as mycost8,
(quant9 unit9) as mycost9,
(quant10 unit10) as mycost10,
((quant1 unit1) + (quant2 unit2) + (quant3 unit3) + (quant4 unit4) + (quant5 unit5) + (quant6 unit6) + (quant7 unit7) + (quant8 unit8) + (quant9 unit9) + (quant10 unit10) + delivery) as mytotal
From `orderform`
thanks
adam
