<?php



include('db-connect.php');



$row1 = mysqli_query($con,"SELECT *,trfstandards.iddpicategory as iddpicategoryid,trfstandards.idprotectioncategory as idprotectioncategoryid,trfstandards.idstandards as idstandardsid FROM trfstandards LEFT JOIN standards ON trfstandards.idstandards=standards.idstandards LEFT JOIN dpicategory ON trfstandards.iddpicategory=dpicategory.iddpicategory LEFT JOIN protectioncategory ON trfstandards.idprotectioncategory=protectioncategory.idprotectioncategory WHERE trfstandards.idtrfdetails='{$_GET['idtrf']}' order by standardcode");



$html = "<table class=\"table table-striped mb-0\" id=\"example1\" style=\"border:1px solide red\">

			<tr>

				<th style=\"display:none;\">id</th>

				<th>{$_GET['standardcodetitle']}</th>

				<th>{$_GET['protectioncategorytitle']}</th>

				<th>{$_GET['dpicategorytitle']}</th>

			</tr>";

			

			while($rowquery = mysqli_fetch_assoc($row1)) {

				$this_pcat = (isset($rowquery['name_protectioncategory']))? $rowquery['name_protectioncategory']: $_GET['pleaseselectstd'];

				$this_dpcat = (isset($rowquery['value_dpicategory']))? $rowquery['value_dpicategory']: $_GET['pleaseselectstd'];

				$html .= "<tr>

							<td style=\"display:none;\">{$rowquery['idtrfstandards']}</td>

							<td>{$rowquery['standardcode']}</td>

							<td>{$this_pcat}</td>

							<td>{$this_dpcat}</td>

						</tr>";

			}

			

        $html .= "</table>";

		

echo $html;

?>