I am trying to insert into a database the current rate multiplied by the mileage with an if statement. I need the mileage to be doubled if the journey is a return journey.
Tried some code which is posted below but struggling to make it work as it just takes the else line of code without considering if its no a return.
returntrip is posted from a form with the value of Y for yes, N for no. I want amount to equal multiply the rate which is posted from the form by the mileage but the mileage could be exact as entered on the form if not a return journey or multiplied if a return journey.
$tripis = $returntrip;
if ($tripis="Y"){
$checkmiles = $mileage * 2;
} else {
$checkmiles = $mileage;
}
$amount = $rate * $checkmiles;
The above code just inserts the else regardless if the returntrip value is Y or N.