<script language="JavaScript">
    alert('Its worked!');
</script>

<form method="POST" onsubmit="this.action=window.location.hash= '#metka-1';this.submit()">
  <p align="center">
    <select name="ddate" >
        <option value = ""> ЧИСЛО
        <option value="1">1 </option>
        <option value="2">2 </option>
        <option value="3">3 </option>
        <option value="4">4 </option>
        <option value="5">5 </option>
        <option value="6">6 </option>
        <option value="7">7 </option>
        <option value="8">8 </option>
        <option value="9">9 </option>
        <option value="10">10 </option>
        <option value="11">11 </option>
        <option value="12">12 </option>
        <option value="13">13 </option>
        <option value="14">14 </option>
        <option value="15">15 </option>
        <option value="16">16 </option>
        <option value="17">17 </option>
        <option value="18">18 </option>
        <option value="19">19 </option>
        <option value="20">20 </option>
        <option value="21">21 </option>
        <option value="22">22 </option>
        <option value="23">23 </option>
        <option value="24">24 </option>
        <option value="25">25 </option>
        <option value="26">26 </option>
        <option value="27">27 </option>
        <option value="28">28 </option>
        <option value="29">29 </option>
        <option value="30">30 </option>
        <option value="31">31 </option>
    </select>
      <select name="month">
        <option value = ""> МЕСЯЦ
        <option value="1">Январь </option>
        <option value="2">Февраль </option>
        <option value="3">Март </option>
        <option value="4">Апрель </option>
        <option value="5">Май </option>
        <option value="6">Июнь </option>
        <option value="7">Июль </option>
        <option value="8">Август </option>
        <option value="9">Сентябрь </option>
        <option value="10">Октябрь </option>
        <option value="11">Ноябрь </option>
        <option value="12">Декабрь </option>
    </select>
    <select name="yyear" >
      <option value="">ГОД</option>
      <option value="2012">2012</option>
    </select>    
  <p align="center">
      <input name="submit" type="submit" value="ПОИСК!">
</form>
<A NAME="metka-1"> </A> 
<?php
include ('connect_astro.php');

$month = $_POST['month'];
$ddate = $_POST['ddate'];
$year = $_POST['yyear'];

if ((empty($ddate))||(empty($month))||(empty($year)))
{ echo '<p align="center"><strong>ВВЕДИТЕ ДАТУ РОЖДЕНИЯ</strong> ';}

$sql=" SELECT tab_planets1.descrip as dd1, tab_planets2.descrip as dd2, tab_planets3.descrip as dd3, tab_planets4.descrip as dd4, tab_planets5.descrip as dd5, tab_planets6.descrip as dd6, tab_planets7.descrip as dd7, tab_planets8.descrip as dd8, tab_planets9.descrip as dd9, 
tab_planets10.descrip as dd10, tab_planets11.descrip as dd11, tab_planets12.descrip as dd12
FROM tab_astro tab_astro1
LEFT JOIN tab_planets tab_planets1 ON tab_astro1.plan1 = tab_planets1.planets
LEFT JOIN tab_planets tab_planets2 ON tab_astro1.plan2 = tab_planets2.planets
LEFT JOIN tab_planets tab_planets3 ON tab_astro1.plan3 = tab_planets3.planets
LEFT JOIN tab_planets tab_planets4 ON tab_astro1.plan4 = tab_planets4.planets
LEFT JOIN tab_planets tab_planets5 ON tab_astro1.plan5 = tab_planets5.planets
LEFT JOIN tab_planets tab_planets6 ON tab_astro1.plan6 = tab_planets6.planets
LEFT JOIN tab_planets tab_planets7 ON tab_astro1.plan7 = tab_planets7.planets
LEFT JOIN tab_planets tab_planets8 ON tab_astro1.plan8 = tab_planets8.planets
LEFT JOIN tab_planets tab_planets9 ON tab_astro1.plan9 = tab_planets9.planets
LEFT JOIN tab_planets tab_planets10 ON tab_astro1.plan10 = tab_planets10.planets
LEFT JOIN tab_planets tab_planets11 ON tab_astro1.plan11 = tab_planets11.planets
LEFT JOIN tab_planets tab_planets12 ON tab_astro1.plan12 = tab_planets12.planets
WHERE (tab_astro1.month='$month'AND tab_astro1.ddate='$ddate' AND tab_astro1.year='$year')";

//В переменной  сохраняем результаты выборки 



$ress=mysql_query($sql); 


while ($astroinfo=mysql_fetch_array($ress))
{
echo '<br /> <br /> 
'.$astroinfo["dd1"].'  
'.$astroinfo["dd2"].' 
'.$astroinfo["dd3"].'  
'.$astroinfo["dd4"].' 
'.$astroinfo["dd5"].'  
'.$astroinfo["dd6"].' 
'.$astroinfo["dd7"].'
'.$astroinfo["dd8"].' 
'.$astroinfo["dd9"].'
'.$astroinfo["dd10"].' 
'.$astroinfo["dd11"].'
'.$astroinfo["dd12"].'';
}




?>