湖濱散記部落格的樹心幽徑(lt_gallery_resources)<hr>
<table border=1><tr bgcolor=yellow><td>resources id  <td>file_name <td> file_size <td>owner_id <td>album_id <td>date
<tr><td bgcolor=pink align=center>1351<td> <a href=download.php?file=20170911文字編輯與格式設定.doc>20170911文字編輯與格式設定.doc</a><td>29696<td>70<td>230<td>2017-09-10 22:08:09<tr><td bgcolor=pink align=center>990<td> <a href=download.php?file=20150521抓圖.doc>20150521抓圖.doc</a><td>538624<td>70<td>230<td>2015-05-20 21:18:06<tr><td bgcolor=pink align=center>988<td> <a href=download.php?file=20150519db.xls>20150519db.xls</a><td>19456<td>70<td>230<td>2015-05-19 00:18:28<tr><td bgcolor=pink align=center>987<td> <a href=download.php?file=20150519Excel資料庫應用.doc>20150519Excel資料庫應用.doc</a><td>25600<td>70<td>230<td>2015-05-19 00:18:28<tr><td bgcolor=pink align=center>984<td> <a href=download.php?file=20150512MapSource電子地圖.doc>20150512MapSource電子地圖.doc</a><td>24576<td>70<td>230<td>2015-05-12 00:00:18<tr><td bgcolor=pink align=center>979<td> <a href=download.php?file=20150317frontPage.doc>20150317frontPage.doc</a><td>25088<td>70<td>230<td>2015-05-05 00:19:21<tr><td bgcolor=pink align=center>978<td> <a href=download.php?file=20131220金門農工大辦公室DocuPrint255XP印表機安裝步驟.doc>20131220金門農工大辦公室DocuPrint255XP印表機安裝步驟.doc</a><td>934400<td>70<td>230<td>2015-05-05 00:17:21<tr><td bgcolor=pink align=center>977<td> <a href=download.php?file=20150505區域網路操作.doc>20150505區域網路操作.doc</a><td>24576<td>70<td>230<td>2015-05-05 00:17:05<tr><td bgcolor=pink align=center>976<td> <a href=download.php?file=20150428裝GarminMapSource.doc>20150428裝GarminMapSource.doc</a><td>25600<td>70<td>230<td>2015-04-27 23:57:06<tr><td bgcolor=pink align=center>975<td> <a href=download.php?file=20150421autocad溫室立体圖.doc>20150421autocad溫室立体圖.doc</a><td>25088<td>70<td>230<td>2015-04-21 00:12:38<tr><td bgcolor=pink align=center>974<td> <a href=download.php?file=20150414autocad農場配置圖.doc>20150414autocad農場配置圖.doc</a><td>24576<td>70<td>230<td>2015-04-14 00:08:57<tr><td bgcolor=pink align=center>970<td> <a href=download.php?file=20150407園三Access-2.doc>20150407園三Access-2.doc</a><td>25600<td>70<td>230<td>2015-04-07 00:10:41<tr><td bgcolor=pink align=center>969<td> <a href=download.php?file=20150331園三Access-1.doc>20150331園三Access-1.doc</a><td>24576<td>70<td>230<td>2015-03-31 00:10:49<tr><td bgcolor=pink align=center>964<td> <a href=download.php?file=20150324園三網頁表格講義.doc>20150324園三網頁表格講義.doc</a><td>24576<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>963<td> <a href=download.php?file=20150303園三MV.doc>20150303園三MV.doc</a><td>24576<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>962<td> <a href=download.php?file=20150127園三排序與篩選.xls>20150127園三排序與篩選.xls</a><td>16896<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>961<td> <a href=download.php?file=20150113統計圖表排序與列印.xls>20150113統計圖表排序與列印.xls</a><td>23552<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>960<td> <a href=download.php?file=20141223園三Book1.xls>20141223園三Book1.xls</a><td>16896<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>959<td> <a href=download.php?file=20141216園三簡報.ppt>20141216園三簡報.ppt</a><td>224768<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>958<td> <a href=download.php?file=20141125園三word圖表.doc>20141125園三word圖表.doc</a><td>644096<td>70<td>230<td>2015-03-24 00:19:56<tr><td bgcolor=pink align=center>952<td> <a href=download.php?file=20140909excel成績表.xls>20140909excel成績表.xls</a><td>18944<td>70<td>230<td>2015-03-24 00:18:49<tr><td bgcolor=pink align=center>953<td> <a href=download.php?file=20140911園三舞樂道2.doc>20140911園三舞樂道2.doc</a><td>25088<td>70<td>230<td>2015-03-24 00:18:49<tr><td bgcolor=pink align=center>954<td> <a href=download.php?file=20141021得盡諸苦際.doc>20141021得盡諸苦際.doc</a><td>19968<td>70<td>230<td>2015-03-24 00:18:49<tr><td bgcolor=pink align=center>955<td> <a href=download.php?file=20141021園三無蝦米.doc>20141021園三無蝦米.doc</a><td>31232<td>70<td>230<td>2015-03-24 00:18:49<tr><td bgcolor=pink align=center>956<td> <a href=download.php?file=20141104園三word格式.doc>20141104園三word格式.doc</a><td>27648<td>70<td>230<td>2015-03-24 00:18:49<tr><td bgcolor=pink align=center>957<td> <a href=download.php?file=20141118園三word.doc>20141118園三word.doc</a><td>298496<td>70<td>230<td>2015-03-24 00:18:49<tr><td bgcolor=pink align=center>951<td> <a href=download.php?file=20140106園三函數.xls>20140106園三函數.xls</a><td>17408<td>70<td>230<td>2015-03-24 00:18:49</table>
計 27 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=230 order by date desc; ok.