query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getGuide = "SELECT * FROM `table-guide_data` WHERE `deleted`='0' AND `title_id`= '$titleID' ORDER BY `seq_no` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getStep = mysqli_query($conn,$getGuide);
$statRow = mysqli_num_rows($getStep);
echo "";
echo "";
echo "| NO | ";
echo "STEP-BY-STEP INSTRUCTION | ";
echo "";
if($statRow > 0){
while($row = mysqli_fetch_array($getStep)){
$count = $count + 1;
?>".$row['seq_no'] ."";
echo "| ".$row['description']." | ";
echo "
";
}
}
echo "
";
$conn->close();
}
?>