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

    Select records where result in PHP array – MySql

    9th March 2020

    MySql

    mysql codehaven category

    This code will delete any record it finds with a clientid of either 1,2,3,4 and an factorid of 71.

    1
    2
    3
    4
    5
    6
     
    $myrowid = array('1','2','3','4');
    $myrowid = implode("','", $myrowid);
     
    $sql = "DELETE FROM tasksdone WHERE clientid IN ('".$myrowid."') and factorid = '71' ";
     

    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