1 Page insurance formula using mysql and php

[oracle765]

Insurer, age min, age max, duration min, duration max, duration unit, single r1,duo r1,family r1,single r2,duo r2,family r2


insurer1, 0,59, 1,5,days,$16.24,$32.48,$50.00,$17.60,$35.20,$57.00
insurer2, 0,49, 1,2,months,$206.24,$302.48,$500.00,$170.60,$350.20,$570.00
insurer1, 60,79, 22,29,days,$160.24,$320.48,$500.00,$170.60,$350.20,$563.00
insurer2, 50,65, 1,5,days,$16.24,$32.48,$50.00,$17.60,$35.20,$57.00


so something like

select * from the database where the text boxes that the user has filled in match this criteria

EG (worldiwide)WW=R1,(Pacific)PC=R2

Single= single price
Duo= duo price x 2 people
Family, not sure if it is used

days between for some insurers as they only use days
but some insurers use days and months for instance between 2 and 3 months calculate the month field 05 for may 03 for march 05 - 03 = 2 months

SO as you can see this can get quite complicated and I am only new to sql and php


If anyone has experience or feels they can do this then let me know


admin@compareandchoose.com.au

Hi we are a comparison site and we are trying to calculate a formula to present to our users various prices for travel insurance, at that stage they will be able to click through to their chosen insurer.

 

 

I have managed to code a bit of it but to be honest I am just lost.

 

The format of some of the spreadsheets are something like the attached

 

 

thanks

 

you can see an example on compareandchoose.com.au