выпадающий список и изменение значения

<?php
$db = mysql_connect ("localhost","root","");
mysql_select_db("test",$db);
 
if(isset($_POST['val']))
    $val = $_POST['val'];
else
    $val = "grivna";
 
$result = mysql_query("SELECT name, $val FROM products",$db);
 
echo '<form method="post"><select name="val"><option value="grivna">Гривна</option><option value="dollar">Доллар</option></select><input type="submit" value="Показать"></form>';
echo '<table border=1>
<tr><td>Наименование</td><td>Стоимость</td></tr>';
while($myrow = mysql_fetch_row($result))
echo '<tr><td>' .$myrow[0]. '</td><td>' .$myrow[1]. '</td></tr>';
 
echo '</table>';
?>

<?
mysql_connect('-----', '---','----')
  or die ("Could not connect to MySQL");
 
mysql_select_db ('----')
  or die ("Could not select database");
 
 
 
if(isset($_POST['val']))
    $val = $_POST['val'];
else
    $val = "priceUAH";
 
$result = mysql_query("SELECT name, $val FROM shop");
 
echo '<form method="post"><select name="val"><option value="priceUAH">Гривна</option><option value="price">Доллар</option></select><input type="submit" value="Показать"></form>';
echo '<table border=1>
<tr><td>Наименование</td><td>Стоимость</td></tr>';
while($myrow = mysql_fetch_row($result))
echo '<tr><td>' .$myrow[0]. '</td><td>' .$myrow[1]. '</td></tr>';
 
echo '</table>';
$result=mysql_query("select count(1) from shop");
$row = mysql_fetch_array($result);
$perpage=2;
$countpage=ceil($row[0]/$perpage);
$page=$_GET['id'];
 
if(!isset($page))
{
echo "Добро пожаловать в мой интернет магазин! Выбирайте мою продукцию <br>";
for ($i=1;$i<=$countpage;$i++)
{
echo "<a href=index.php?id=$i>$i</a> ";
}
}
else
{
$myrow = mysql_fetch_row($result);
$offset=($page-1)*$perpage;
$pag1=$page++;
$sql2="SELECT * FROM shop limit $offset,$perpage";
$result2=mysql_query($sql2) or die(mysql_error());
while($content=mysql_fetch_array($result2))
{
echo "<br> $content[desc] <br> <b> Цена:$content[price] у.е. </b> <a href=beyotch/index.php?page=shop&action=add&id=$content[id]>В корзину</a>";
}
echo "<br><a href=index.php>Back</a>";
 
}
 
echo"<br><center><a href=http://артур.ваня.in.ua/index.php?session=1>Выйти</a></center>";

echo '<form name="form1" method="post"><select name="val" onchange="form1.submit()"><option value="priceUAH"' .($val=="priceUAH" ? " selected": "").'>Гривна</option><option value="price"' .($val=="price" ? " selected": "").'>Доллар</option></select></form>';