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


$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'];
}
}