如何从mysql中的那天加载{html_select_date}中的那一天

i need to display the drop down when the day is come from mysql

my query is

select doj from user_detatils where user_id='2'

i use the html_select_date for the drop down option

The code is below

 {html_select_date start_year=1970 month_format="%b" field_order="dmy" 
  field_array="date" prefix="" day_id="dd" month_id="mm" year_id="yy" 
  year_empty="Year" month_empty="Month" day_empty="Day" }

if the table return the doj that date will be select in the drop down else the drop down didn't select any value

Following up on how can change the numeric to month in words.

{html_select_date} explains the time argument. granted, it does a poor job in explaining that time=null will lead to "no date selected" and anything else that evaluates falsy (false, 0, "", …) will select the "current date".

So your PHP should check if the database has a valid date in doj, otherwise set that variable to null.