if ($SerchOptioncount == 0) { $querymemo = ""; } $x = $querymemo; } $queryarray[] = "SELECT id FROM list WHERE year in(" . implode(") UNION (", $input[$SerchOption]) . ")"; break; case "code": $input[$SerchOption] = array_map(function ($x) { return explode(",", $x); }, $input[$SerchOption]); foreach ($input[$SerchOption] as &$x) { $SerchOptioncount = 0; $querymemo = "SELECT DISTINCT(D0.id) FROM"; foreach ($x as &$y) { $y = $db->escape($y); $memo = ""; $memo = "(SELECT id FROM summary WHERE code LIKE '%{$y}%' ) as D{$SerchOptioncount} "; if ($SerchOptioncount > 0) { $querymemo .= " JOIN " . $memo . "ON D0.id = D{$SerchOptioncount}.id"; } else { $querymemo .= $memo; } $SerchOptioncount++; } $x = $querymemo; } $queryarray[] = "SELECT id FROM summary WHERE id in(" . implode(") UNION (", $input[$SerchOption]) . ")"; break; case "schedule": $input[$SerchOption] = array_map(function ($x) {