How to display from SQL tblproducts -- recurringcycles column

[mcmasters]

Please Help..

Reccuring can be confusing -- the client does not see an end date in the cart.

 

If recurringcycles is greater then 0 then display "for XX Months"

 

Something like following...

{if $pricing.monthly} AND recurringcycles COLUMN is =0 THEN  THIS---><option value="monthly"{if $billingcycle eq "monthly"} selected="selected"{/if}>{$pricing.monthly}</option>{/if}

{if $pricing.monthly} AND recurringcycles COLUMN is >0 THEN  THIS---><option value="for  $recurringcycles month's "{if $billingcycle eq "monthly"} selected="selected"{/if}>{$pricing.Limit.monthly}</option>{/if}

 

Essentially just pull the reccurringcycle from the table and input the number into the <option value="for XX month's" if greater than zero.

 

Cheers,

McMasters

Edited February 14, 2012 by mcmasters