Пример вывода данных из БД в выпадающий список

$query = "select * from `region`";
$result_select = mysql_query($query);
?>
<form method="get" action="#">
<select onchange="load_transport(this)" name="raion" id="findselect"><p>
<?php while($object = mysql_fetch_object($result_select)):?>
<option value="0"><?=$object->name?><?=$object->name?></option>
<?php endwhile;?>
</select>

<?php
$user="test22";
$host="localhost";
$password="12345";
$db="test22";
mysql_connect($host, $user, $password) or die("MySQL Ошибка!".mysql_error());
mysql_select_db($db) or die("Нет соединения".mysql_error());
mysql_query("SET NAMES 'utf8'");
?>

$result_select = mysql_query($query);

$sql = mysql_connect ($host, $user, $password) or die("MySQL Ошибка!".mysql_error());
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");
mysql_select_db($db,$sql) or die("Нет соединения".mysql_error());

$query = "select * from `region`";
$result_select = mysql_query($query);
?>
<form method="get" action="#">
<select onchange="load_transport(this)" name="raion" id="findselect"><p>
<?php 
while($object = mysql_fetch_array($result_select))
echo"<option value="0">$object[name]</option>";
mysql_free_result($sub_razdel); ?>
</select></form>

echo"<option value="0">$object[name]</option>";

<option value="0">echo $object[name]</option>

$object[name]

echo'<option value="0">$object[name];</option>';

$query = "select * from `region`";
$result_select = mysql_query($query);?>
<form method="get" action="#">
<select onchange="load_transport(this)" name="raion" id="findselect"><p>
<?while($object = mysql_fetch_array($result_select))
echo"<option value='0'>$object[name]</option>";
mysql_free_result($sub_razdel);?>
</select>

$query = "select * from `region`";
$result_select = mysql_query($query);?>
<form method="get" action="#">
<select onchange="load_transport(this)" name="raion" id="findselect"><p>
<?while($object = mysql_fetch_array($result_select))?>
<option value='0'><?echo $object['name'];?></option>";
mysql_free_result($sub_razdel);?>
</select>

echo"<option value='0'>$object['name']</option>";

echo"<option value='0'>".$object['name']."</option>";