problems at linking between two drop down menus
<p>I have creat a DB &amp; some of my pages need 2 drop down 
 for example in edit page the first one retrive the Category  (no problem here)
the secound should retrive(bring) the articals depends on the first drop down selected item-they are in the same web page(edit1.php)
my code is:</p>

<pre><code>&lt;form  action="edit1.php" method="post" name="artical" id="artical"&gt;
choose Catagory:&lt;br/&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;select name="c" id="c"&gt; 
&lt;?php

        $qry="SELECT * FROM category";
        $result=mysql_query($qry);
        if($result) {
            while($info = mysql_fetch_array( $result )) 
            { 
                Print "&lt;option value='www.technews.311web.com/category.php?id=".$info['id']."'&gt;".$info['name'] . "&lt;/option&gt;";

            } 
        }

    ?&gt; 
    &lt;br/&gt;
&lt;/select&gt;
&lt;br/&gt; 
 &lt;input type="submit" name="submit" value ="go "/&gt;
 &lt;br/&gt;&lt;/form&gt;
&lt;form method="get"&gt;
&lt;br/&gt;
choose artical:&lt;br/&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;select name="artical" id="article"&gt; 
&lt;?php
$options = $_POST['c'];

    $qry="SELECT * FROM article WHERE id='".$options."';";
    $result=mysql_query($qry);//
    //Retrieve all articles from DB:
    //Create query
    //$qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])."'";

    //$qry="SELECT * FROM article ";
    //$result=mysql_query($qry);

    if($result) {
            while($info = mysql_fetch_array( $result )) 
            { 
                Print "&lt;option value='" .$info['id']."'&gt;" .$info['title'] . "&lt;/option&gt;";
            } 
        }

    ?&gt;
    &lt;/select&gt;
&lt;/form&gt;
</code></pre>
