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

    SUM and GROUP BY

    5th November 2013

    MySql

    mysql codehaven category

    1
    2
    3
     
    $result = mysql_query("SELECT SUM(conversions) AS mysum,campaign FROM table WHERE client='$client' AND date BETWEEN '$startdate' AND '$enddate' and time = 23 group by campaign");
     

    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