如何取月录明智

Question

下拉月份和年份，然后提交。

<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 

等....

像显示报告： test1的是当月 test2的是上一个。月 等

当我在当前月份报告第一次显示时加载页面时，如何每月取回记录？

Answer 1

select * 
    from MyTable 
where MONTH(FROM_UNIXTIME(time)) = MONTH(NOW())