subtracting a value from a row in mysql using radio button

[dardime]

Hi i need help on subtracting a value stored on mysql row using radio buttons in php. Only if you select NO it will deduct 5. Thank you

 

Please find screenshot. Thanks

Edited August 15, 2017 by dardime

[benanamen]

What have you tried?

[dardime]

Hi

 

I have tried using an if statement condition:

<?php if($_SESSION['power']=='No' && $_SESSION['display']=='No' && $_SESSION['liquid']=='Yes' && $_SESSION['buttons']=='Yes' && $_SESSION['enclosure']=='Yes') {?>
             <div class="pricefont"><b>$<?php echo $result["price3d"]; ?></b></div> Quoted Price<br><br>
             <?php } ?>

And i have these values stored in price, price2d, price3d, price4d, price5d amd whatever the condition met it outputs the value in row. It will show the value but i don't know how to insert this value to database as its only a result.

If it can be then  it will solve my problem. Please find screenshot

[dardime]

Hi All 

 

Thank you i have sorted this out. Thanks heaps!

[dardime]

<?php 

    if($_SESSION['power']=='No' && $_SESSION['display']=='No' && $_SESSION['liquid']=='Yes' && $_SESSION['buttons']=='Yes' && $_SESSION['enclosure']=='Yes') 

     {

         $quotedprice = $result["price3d"]; 

     } 

?>

 

Edited August 15, 2017 by dardime

[Jacques1]

I have absolutely no idea what you're doing there. Are you manually going through all 32 possible cases?

[dardime]

Any solutions from you please? Yes i have to add each cases....

[Jacques1]

So how does the calculation work exactly? You start with a base price, and each defect reduces it by 5.00? Then simply count the “No” selections.

price = base_price − defect_count × 5.00  

Note that with some of your example data, the result will be 0.00 if all selections are “No”.