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

    Build a mysql statement dynamically

    17th June 2013

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
     
    if ($clientselect) {
        $sql[] = " client = '$clientselect' ";
    }
     
    $query = "SELECT * FROM cmdata WHERE time=$thishour AND date='$thisday' AND cpa = '0.00'";
     
    if (!empty($sql)) {
        $query .= ' AND ' . implode(' AND ', $sql);
    }
     
    echo $query;
    $result2 = mysql_query($query);
     

    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