<?php include('db_con.php'); ?>

<?php

function option_building_location()
{
	include('db_con.php');
	
	$get_bd_name ="select * from bd_locationtb";
	$run_bd_name = mysqli_query($con,$get_bd_name);
	while($row_bd_name = mysqli_fetch_array($run_bd_name))
	{
		$building_location = $row_bd_name['location_name'];
		echo"<option>$building_location</option>";
	}
	
	
}

?>
<?php


function option_building_name()
{
	include('db_con.php');
	
	$get_bd_name ="select * from main_buildingtb";
	$run_get_bd_name = mysqli_query($con,$get_bd_name);
	while($row_get_bd_name = mysqli_fetch_array($run_get_bd_name))
	{
		$building_name = $row_get_bd_name['building_name'];
		echo"<option>$building_name</option>";
	}
	
	
}


?>