รบกวนสอบถามเรื่องการดึงข้อมูลในฐานข้อมูลมาแสดงใน bootstrap 4 modal โดยใช้เงื่อนไข id จากรายการที่คลิก คะ

<!-- start data table -->
              <table class="table table-bordered table-striped">
                <thead>
                <tr>
						<th></th>
                        <th>เรื่อง</th>
                        <th>จังหวัดที่เกิดเหตุการณ์</th>
                        <th>วันที่เกิดเรื่อง</th>
                        <th>วันที่แจ้งเรื่อง</th>
						<th>ผู้แจ้ง </th>
						<th>ผู้บันทึก</th>
						<th>สถานะ</th>
						<th>ปัญหาที่เกี่ยวข้อง</th>
                        
                </tr>
                </thead>
                <tbody id="myTable">
<?php
	while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
	{
	
		if($curentDate= date('Y-m-d H:i:s') < $deathLine=date('Y-m-d H:i:s',strtotime('+24 hour',strtotime($result["INSERT_DATETIME"]))))
		{
			echo "<tr>";
			echo "<td><img src='image/green-button.jpg' width='30px' title ='สถานะ : เรื่องมาใหม่' height ='30px'></td>";
    		echo "<td><a href='editevent.php?UID=".$_GET["UID"]."&S=".$_GET["S"]."&EventID=".$result["USER_ID"]."&EVID=".$result["INSERT_DATETIME"]."' class='edit' title='Edit' data-toggle='tooltip'>".$result["EVENT_NAME"]."</a><img src=".$result["EVENT_STATUS_IMAGE"]."></td>";
			echo "<td>".$result["EVENT_PROVINCE"]."</td>";
			echo "<td >".thai_dateshort(strtotime($result["EVENT_DATETIME"]))."</td>";
			echo "<td >".thai_dateshort(strtotime($result["test"]))."</td>";
			echo "<td>".$result["PERS_FIRSTNAME"]."</td>";
			echo "<td>".$result["USER_FIRSTNAME"]."</td>";
			echo "<td >".$result["EVENT_STATUS_NAME"]."</td>";
			echo "<td><input type='button' name='view' value='view' data-id='".$result["INSERT_DATETIME"]."'class='btn btn-info btn-xs view_data' data-toggle='modal'  data-target='#issue'/></td>";
			//echo "<td><input type='button' name='view' value='view' id='".$result["INSERT_DATETIME"]."' class='btn btn-info btn-xs view_data' /></td>";
			//echo "<td><a type='button' class='btn btn-info btn-xs view_data' href='#issue' data-toggle='modal' data-toggle='tooltip' title='View'>View</a></td>";
			echo "</tr>";
			//echo thai_dateshort($edate);
		
		}
		else
		{
			echo "<tr>";
			echo "<td><img src='image/red-button.jpg' width='30px' title ='สถานะ : เกิน 24 ชม.' height ='30px'></td>";
    		echo "<td><a href='editevent.php?UID=".$_GET["UID"]."&S=".$_GET["S"]."&EventID=".$result["USER_ID"]."&EVID=".$result["INSERT_DATETIME"]."' class='edit' title='Edit' data-toggle='tooltip'>".$result["EVENT_NAME"]."</a><img src=".$result["EVENT_STATUS_IMAGE"]."></td>";
			echo "<td>".$result["EVENT_PROVINCE"]."</td>";
			echo "<td >".thai_dateshort(strtotime($result["EVENT_DATETIME"]))."</td>";
			echo "<td >".thai_dateshort(strtotime($result["test"]))."</td>";
			echo "<td>".$result["PERS_FIRSTNAME"]."</td>";
			echo "<td>".$result["USER_FIRSTNAME"]."</td>";
			echo "<td >".$result["EVENT_STATUS_NAME"]."</td>";
			echo "<td><input type='button' name='view' value='view' data-id='".$result["INSERT_DATETIME"]."'class='btn btn-info btn-xs view_data' data-toggle='modal'  data-target='#issue'/></td>";
		//echo "<td><input type='button' name='view' value='view' id='".$result["INSERT_DATETIME"]."' class='btn btn-info btn-xs view_data' /></td>";
		//echo "<td><a type='button' class='btn btn-info btn-xs view_data' href='#issue' data-toggle='modal' data-toggle='tooltip' title='View'>View</a></td>";
			echo "</tr>";
		}
		$dateid =  $result["INSERT_DATETIME"];
	}
?>
		</tbody>
		</table>
<!-- End data table -->
			</div>

<!-- start Modal issue -->      
	<div class="modal fade" id="issue" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
		<div class="modal-dialog" role="document">
			<div class="modal-content">
				<div class="modal-header">
					<h5 class="modal-title" id="exampleModalLabel"><font color="#383838">ปัญหาที่เกี่ยวข้อง</font></h5>
					<button type="button" class="close" data-dismiss="modal" aria-label="Close">
					<span aria-hidden="true">&times;</span>
					</button>
				</div>
				<div class="modal-body" id="viewissue"> 

<?php 

					$SQLis = "SELECT 
								es.ISSUE_ID,
								s.ISSUE_NAME,
								es.USER_ID,
								es.INSERT_DATETIME,
								estatus.EVENT_STATUS_ID,
								es.EVENT_STATUS_ID, 
								estatus.EVENT_STATUS_NAME 
			  
							FROM tbl_event_issue as es 
			  
							inner join tbl_event_status as estatus on estatus.EVENT_STATUS_ID = es.EVENT_STATUS_ID 
							inner join tbl_issue as s on es.issue_id = s.issue_id 
			  
							WHERE (es.INSERT_DATETIME = '{$dateid}') AND 
								(es.issue_id = s.issue_id) AND 
								(estatus.EVENT_STATUS_ID = es.EVENT_STATUS_ID) 
							
							ORDER BY es.USER_ID";  

							$queryis = mysqli_query($con, $SQLis);

					$SQLStatus = "SELECT * FROM tbl_event_status";
					$QueryStatus = mysqli_query($con, $SQLStatus);

			echo "<table class='table table-bordered table-striped'>";
			echo "<thead>";
			echo "<tr>";
			echo "<th>ปัญหา</th>";
			echo "<th>สถานะ</th>";
			echo "</tr>";
			echo "</thead>";
			echo"<tbody>";

		while($resultis=mysqli_fetch_array($queryis,MYSQLI_ASSOC))
		{
		  //echo"<input type='text'  class='form-control' id='issueid'>";
			echo"<tr>";
			echo "<td >".$resultis["ISSUE_NAME"]."</td>";
		  //echo "<td >".$resultis["EVENT_STATUS_NAME"]."</td>";
			echo "<td ><select name='status' class='form-control'>";
			echo "<option selected value='".$resultis['EVENT_STATUS_ID'].">".$resultis['EVENT_STATUS_NAME']."</option>";
				
			while($result1=mysqli_fetch_array($QueryStatus,MYSQLI_ASSOC))
			{
				echo "<option value='".$result1['EVENT_STATUS_ID'].">".$result1['EVENT_STATUS_NAME']."</option>";

			}
				echo "</select></td>";
				echo"</tr>";
		}

					  
			echo "</tbody>";
			echo "</table>";
	?>
				</div>  
				<div class="modal-footer">
						<button type="button" class="btn btn-secondary" data-dismiss="modal">ปิด</button>
				</div>
			</div>
		</div>
	</div>

	<!-- End Modal issue -->