PHP dropdown database code not working?
<p>I have an issue with the below code, it is showing the html part but not the data from my database. I am just trying to have the data from the database in the drop down list and when I click <code>find</code> to display it on the table below. Can you please help?</p>

<pre><code>    &lt;?php
    include 'config.php';
?&gt;
&lt;html&gt;
    &lt;head&gt;
        &lt;meta charset="UTF-8"&gt;
        &lt;title&gt;&lt;/title&gt;
    &lt;/head&gt;
    &lt;body&gt;
        &lt;select name="manufacturer"&gt;
            &lt;option value=""&gt;----ALL----&lt;/option&gt;
        &lt;?php
            $sql = "SELECT id, manufacturer FROM coop";
            $result = $conn-&gt;query($sql);
            while ($r = mysqli_fetch_assoc($result))
            {
                echo "&lt;option value='$r[id]'&gt; $r[manufacturer]&lt;/option&gt;";
            }
        ?&gt;
        &lt;/select&gt;
        &lt;input type="submit" name="find" value="find"/&gt;
        &lt;br&gt;&lt;br&gt;

        &lt;table border="1"&gt;
            &lt;tr align="center"&gt;
                &lt;th&gt;ID&lt;/th&gt; &lt;th&gt;Manufacturer&lt;/th&gt;
            &lt;/tr&gt;

            &lt;?php
            if($_SERVER['REQUEST_METHOD'] == "POST")
                {
                    $des=$_POST["manufacturer"];
                    if($des=="")
                    {
                        $result=  mysqli_query("SELECT id, manufacturer FROM coop");
                    }
                    else
                    {
                        $result= mysqli_query($sql);
                    }
                    echo "&lt;tr&gt;&lt;td colspan='5'&gt;&lt;/td&gt;&lt;/tr&gt;";
                    while($r= mysqli_fetch_assoc($result))
                    {
                        echo "&lt;tr&gt;";
                        echo "&lt;td align='center'&gt;$r[0]&lt;/td&gt;";
                        echo "&lt;td width='200'&gt;$r[1]" . " $r[2]&lt;/td&gt;";
                        echo "&lt;td alig='center' width='40'&gt; $r[3]&lt;/td&gt;";
                        echo "&lt;td align='center' width='200'&gt;$r[4]&lt;/td&gt;";
                        echo "&lt;td width='100' align='center'&gt;$r[5]&lt;/td&gt;";
                        echo "&lt;/tr&gt;";
                    }
                }
            ?&gt;
        &lt;/table&gt;
    &lt;/body&gt;
&lt;/html&gt;
</code></pre>