codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Percentage – Maths in Mysql Statement – Cast

    8th October 2013

    MySql

    mysql codehaven category

    1
    2
    3
     
    $query3 = "SELECT targetcpa, predictedcpa, CAST( targetcpa * 0.25 AS DECIMAL (6,2) ) AS percentage FROM targets";
     

    Percentage will now show targetcpa with an extra 25% on it.

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN