ake form information (formidable):
Prize value (id 75)
# of Players (id 76)
Yardage (id 78) – minimum of 165
If id78 <150 set yardage = 'yardage_140-149' elseif id78 <165 set yardage = 'yardage_150-164' else set yardage = 'yardage_165' If id76 <=71 set playercol = players_60 elsif id76 <=99 set playercol = players_72 elsif id76 <=130 set playercol = players_100 elseif id76 <=143 set playercol = players_131 elsif id76 <=188 set playercol = players_144 elsif id76 <=239 set playercol = players_189 else set playercol = players_240 SELECT quotevalID FROM yardage WHERE (id79 >= Prize_Start AND id 79 <=Prize_End) SELECT playercol FROM yardage WHERE quotevalID = quotevalID ** SELECT playercol FROM yardage WHERE `quotevalid` = ( SELECT `quotevalid` from yardge WHERE id79 >= Prize_Start AND id79 <= Prize_End); ** Ex. SELECT players_189 FROM `yardage_165` WHERE `quotevalid` = ( SELECT `quotevalid` from yardage_165 WHERE 18000 >= Prize_Start AND 18000 <= Prize_End); Then return this value to a QuoteResult Form and build an invoice to pay [formidable id="8"]
