SQL query won't populate my drop-down box
I have a problem with this query and drop down box:
$ziua = "SELECT DISTINCT DA开发者_运维问答YOFMONTH(ziua) FROM rapoarte";
$ziuaResult = mysql_query($ziua);
Populating the drop down box :
echo"<td>Selectati Ziua:</td>
<td><select name='ziua'>
<option value='---'>---</option>";
while($ziuaRow = mysql_fetch_array($ziuaResult))
{
$ziua1 = $ziuaRow['ziua'];
echo "<option value='$ziua1'>$ziua1</option>";
}
For an reason unknown to me, the drop down box is populated, but no values are shown. (there are 2-3 empty options)
That happens because there is no such column ziua
in your query. Use alias in the query SELECT DISTINCT DAYOFMONTH(ziua) as dm FROM rapoarte
and then $ziua1 = $ziuaRow['dm'];
or access result by integer index $ziua1 = $ziuaRow[0];
The problem is that the field name is not correct. I have tried that as well. It will give you the reult.
精彩评论