Check if a list of ids all exist in MySQL and PHP -
what efficient way in mysql , php check if list of ids exist? want function return result true if all ids exists, else false . i thinking: $ids = array(2233, 5545, 9478, 5343, 3545); do_all_groups_exist($ids); function do_all_groups_exist(array $ids = array()) { if(empty($ids)) { return true; } $sql = "select count(`id`) count groups `id` in (" . implode(',', $ids) . ")"; ... $row = mysqli_fetch_object($result); return (intval($row->count) === count($ids)) ? true : false; } is there better way? you can result in sql statement itself $countids= count($ids); $sql= "select case when ( select count(id) cnt groups id in (" . implode(',', $ids) . ") )=$countids 'true' else 'false' end result" ... $row=mysqli_fetch_array($re
