Problem with PHP printing in drop down box
<p>I have a mysql query:</p>

<p><code>$ziua = "SELECT DISTINCT DAYOFMONTH(ziua) FROM rapoarte";
$ziuaResult = mysql_query($ziua);</code></p>

<p>With the results i get, i want to add them in a drop down box, like this:
`
            echo"Selectati Ziua:</p>

<pre><code>            &lt;td&gt;&lt;select name='ziua'&gt;
            &lt;option value='---'&gt;---&lt;/option&gt;";
        while($ziuaRow = mysql_fetch_array($ziuaResult)) {
         $ziua1 = $ziuaRow['ziua'];
         echo "&lt;option value='$ziua1'&gt;$ziua1&lt;/option&gt;";
        }
</code></pre>

<p>echo""; </p>

<p>`</p>

<p>the problem is that my drop-down boxes are empty. there are 2, 3 options (depending on the select result), but no text is shown.</p>

<p>I have the same problem with this selection:
<code>SELECT DISTINCT HOUR(ora) FROM rapoarte</code></p>

<p>How can i fix this?</p>

<p>thanks,
Sebastian</p>

<p><strong>EDIT</strong></p>

<p>sorry, 
i added the wrong code.</p>
