<?php
$res=$mysqli->query("SELECT id,GROUP_CONCAT(client_id) as clients FROM services WHERE id = 3 GROUP BY id");
$row = $res->fetch_array(MYSQLI_ASSOC);
$result = $row['clients']; // $row['clients'] contains string 5,6,7
$res->free();
$resclients=$mysqli->query("SELECT id,client_name FROM clients WHERE id = IN ($result)");
// handle $resclients
?>
Comments 0