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

    Get sum total and show one result

    24th October 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
     
    $thisday = date("Y-m-d");
    $result = mysql_query("SELECT sum(clicks)  as dog FROM table1
    WHERE date = '$thisday' ");
    $row = mysql_fetch_assoc($result);
     
    echo $row['dog'];
     

    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