php - How to fetch a record monthly wise -

drop down month , year , submit.

<span class="pln">fieldid</span><span class="pun">,</span> <span class="pln"> name</span> <span class="pun">,</span> <span class="pln">&nbsp; &nbsp; &nbsp;time(int)<br></span> <span class="pun">============================</span><span class="pln"><br></span> <span class="lit">1</span> <span class="pln"> &nbsp; &nbsp; &nbsp; &nbsp;test1 &nbsp; &nbsp; </span> <span class="lit">158565545</span><span class="pln"><br></span><span class="lit">2</span> <span class="pln"> &nbsp; &nbsp; &nbsp; &nbsp;test2 &nbsp; &nbsp; </span> <span class="lit">159545222</span><span class="pln"><br></span><span class="lit">3</span> <span class="pln"> &nbsp; &nbsp; &nbsp; &nbsp;test3 &nbsp; &nbsp; </span> <span class="lit">159995545</span><span class="pln"><br></span>  fieldid,  name,    time(int) ============================ 1        test1     158565545 2        test2     152548856 3        test3     159544856 

etc....

show report like: test1 current month test2 prev. month , etc.

how can fetch records monthly-wise when load page first time current month report shows?

select *   mytable  month(from_unixtime(time)) = month(now())