codehaven - php snippets - coding help
[wd_asp elements=’search’ ratio=’100%’ id=1]
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.


$myrowid = array('1','2','3','4');
$myrowid = implode("','", $myrowid);

$sql = "DELETE FROM tasksdone WHERE clientid IN ('".$myrowid."') and factorid = '71' ";