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

    Select records where X is in an array

    26th August 2018

    MySql

    mysql codehaven category

    myselected array contains 4,5,88

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
     
    $sql = "SELECT * FROM workers WHERE id IN (".implode(',',$myselected).")";
     
    if(!$result = $mysqli->query($sql)){
        die('There was an error running the query [' . $mysqli->error . ']');
    }
    while($row = $result->fetch_assoc()){
        echo $row['fname'];
    }
    }
     

    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