Hadi1989

Untitled

Jul 10th, 2018
294
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.40 KB | None | 0 0
  1. <?php
  2.     require 'conn.php';
  3.    
  4.     if(ISSET($_POST['res'])){
  5.         $query = $conn->query("SELECT member.mem_id, member.name, GROUP_CONCAT(skill.skill SEPARATOR ', ') skill FROM `member` LEFT JOIN `skill` ON member.mem_id = skill.mem_id GROUP BY member.mem_id");
  6.         while($fetch = $query->fetch_array()){
  7.        
  8.         echo'
  9.             <tr>
  10.                 <td>'.$fetch['name'].'</td>
  11.                 <td>'.$fetch['skill'].'</td>
  12.             </tr>';
  13.         }
  14.     }
  15. ?>
Advertisement
Add Comment
Please, Sign In to add comment