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

    Join – Get data from two tables using one query

    17th March 2014

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
     
    $query = "SELECT * FROM
     
    (SELECT campaign from targets where client='".$pc_id."' AND enabled !='disabled'
     
      UNION
     
    SELECT groupname AS campaign FROM clientcombine WHERE client='$pc_id')
     
    AS campaign";
     

    Then just collect CAMPAIGN as your row.

    1
    2
    3
    4
    5
    6
    7
    8
     
    $query = "SELECT * FROM
    (SELECT targetcpa AS targetcpa,client FROM targets WHERE client='Dog'
      UNION
    SELECT campaign,client from mydata where date="2014-04-07" AND client='Dog')";
    AS campaign
     

    This above code will combine two sets of data(one from each table) into one….

    Or this

    1
    2
    3
    4
    5
    6
     
    $result = mysql_query("SELECT * FROM tasks
    JOIN residents
    ON residents.id = tasks.forwho
    WHERE tasks.id = '$taskid' ");
     

    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