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

    Select Mutiple Columns as one – Union

    5th May 2015

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
     
    $sql="SELECT item1 FROM user_uploads WHERE item1 LIKE '%$my_data%'
    UNION
    SELECT item2 FROM user_uploads WHERE item2 LIKE '%$my_data%'";
    //they are all item1 now
    $result = mysqli_query($mysqli,$sql) or die(mysqli_error());
    if($result)
    {
    while($row=mysqli_fetch_array($result))
    {
    echo $row['item1']."\n";
    // echo $row['item2']."\n";
    }
    }
     

    Was this code snippet helpful?

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

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

    © 2022 CODEHAVEN