湖濱散記部落格的樹心幽徑(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>1543<td> <a href=download.php?file=20180601cat1.ufo>20180601cat1.ufo</a><td>156672<td>70<td>250<td>2018-06-01 03:54:17<tr><td bgcolor=pink align=center>1541<td> <a href=download.php?file=20180528c++First.doc>20180528c++First.doc</a><td>35328<td>70<td>250<td>2018-05-28 02:59:37<tr><td bgcolor=pink align=center>1540<td> <a href=download.php?file=20180528vbCaLL.png>20180528vbCaLL.png</a><td>131219<td>70<td>250<td>2018-05-28 02:09:48<tr><td bgcolor=pink align=center>1534<td> <a href=download.php?file=20180525vbbyREf.png>20180525vbbyREf.png</a><td>34001<td>70<td>250<td>2018-05-25 04:06:04<tr><td bgcolor=pink align=center>1528<td> <a href=download.php?file=20180521vbF-2.txt>20180521vbF-2.txt</a><td>194<td>70<td>250<td>2018-05-21 02:58:58<tr><td bgcolor=pink align=center>1527<td> <a href=download.php?file=20180521vbF.txt>20180521vbF.txt</a><td>344<td>70<td>250<td>2018-05-21 02:58:58<tr><td bgcolor=pink align=center>1518<td> <a href=download.php?file=20180514vb-sort.png>20180514vb-sort.png</a><td>148469<td>70<td>250<td>2018-05-14 02:08:41<tr><td bgcolor=pink align=center>1514<td> <a href=download.php?file=20180430wu.frm>20180430wu.frm</a><td>3279<td>70<td>250<td>2018-04-30 02:10:01<tr><td bgcolor=pink align=center>1513<td> <a href=download.php?file=20180423VBscriptHTML.png>20180423VBscriptHTML.png</a><td>251649<td>70<td>250<td>2018-04-23 02:01:55<tr><td bgcolor=pink align=center>1512<td> <a href=download.php?file=20180422vbs-1.txt>20180422vbs-1.txt</a><td>613<td>70<td>250<td>2018-04-22 10:27:47<tr><td bgcolor=pink align=center>1508<td> <a href=download.php?file=20180409vb.png>20180409vb.png</a><td>48311<td>70<td>250<td>2018-04-09 02:03:32<tr><td bgcolor=pink align=center>1506<td> <a href=download.php?file=20180402vb.png>20180402vb.png</a><td>97722<td>70<td>250<td>2018-04-02 02:08:39<tr><td bgcolor=pink align=center>1501<td> <a href=download.php?file=20180319VBFIRST.png>20180319VBFIRST.png</a><td>154388<td>70<td>250<td>2018-03-19 02:00:43<tr><td bgcolor=pink align=center>1489<td> <a href=download.php?file=pcbasic150812.png>pcbasic150812.png</a><td>249089<td>70<td>250<td>2018-03-02 03:03:01<tr><td bgcolor=pink align=center>1463<td> <a href=download.php?file=20171222月曆.xls>20171222月曆.xls</a><td>35328<td>70<td>250<td>2017-12-22 03:04:44<tr><td bgcolor=pink align=center>1446<td> <a href=download.php?file=20171214excel成績表.xls>20171214excel成績表.xls</a><td>34304<td>70<td>250<td>2017-12-14 03:28:41<tr><td bgcolor=pink align=center>1407<td> <a href=download.php?file=1407-20171117投影片製作.ppt>1407-20171117投影片製作.ppt</a><td>858624<td>70<td>250<td>2017-11-24 02:37:55<tr><td bgcolor=pink align=center>1405<td> <a href=download.php?file=20171123簡報製作1.ppt>20171123簡報製作1.ppt</a><td>594944<td>70<td>250<td>2017-11-23 03:17:40<tr><td bgcolor=pink align=center>1394<td> <a href=download.php?file=20171116條碼字型應用與EXCEL.doc>20171116條碼字型應用與EXCEL.doc</a><td>129536<td>70<td>250<td>2017-11-16 03:13:38<tr><td bgcolor=pink align=center>1391<td> <a href=download.php?file=20171114軟用丙檢術科word2010第1題文書處理.doc>20171114軟用丙檢術科word2010第1題文書處理.doc</a><td>49152<td>70<td>250<td>2017-11-13 20:59:59<tr><td bgcolor=pink align=center>1385<td> <a href=download.php?file=20171109圖案配置表格轉換樣式複製.doc>20171109圖案配置表格轉換樣式複製.doc</a><td>47104<td>70<td>250<td>2017-11-09 03:16:58<tr><td bgcolor=pink align=center>1377<td> <a href=download.php?file=20171103圖文配置表格轉換樣式複製.doc>20171103圖文配置表格轉換樣式複製.doc</a><td>138752<td>70<td>250<td>2017-11-03 04:03:59<tr><td bgcolor=pink align=center>1376<td> <a href=download.php?file=20171102題組5合併列印.doc>20171102題組5合併列印.doc</a><td>26112<td>70<td>250<td>2017-11-02 04:16:22<tr><td bgcolor=pink align=center>1372<td> <a href=download.php?file=20171019統計圖表與標籤.doc>20171019統計圖表與標籤.doc</a><td>334336<td>70<td>250<td>2017-10-19 04:11:21<tr><td bgcolor=pink align=center>1368<td> <a href=download.php?file=20171005文字方塊頁尾浮水印.doc>20171005文字方塊頁尾浮水印.doc</a><td>174592<td>70<td>250<td>2017-10-05 04:18:13<tr><td bgcolor=pink align=center>1364<td> <a href=download.php?file=20170928定位點分欄框線網底.doc>20170928定位點分欄框線網底.doc</a><td>226816<td>70<td>250<td>2017-09-28 04:22:12<tr><td bgcolor=pink align=center>1353<td> <a href=download.php?file=20170914文字段落格式設定.doc>20170914文字段落格式設定.doc</a><td>28160<td>70<td>250<td>2017-09-14 04:15:24<tr><td bgcolor=pink align=center>1347<td> <a href=download.php?file=20170908文字段落格式設定.doc>20170908文字段落格式設定.doc</a><td>30720<td>70<td>250<td>2017-09-08 04:01:52<tr><td bgcolor=pink align=center>1346<td> <a href=download.php?file=20170907文件編輯與格式設定.doc>20170907文件編輯與格式設定.doc</a><td>31232<td>70<td>250<td>2017-09-07 04:12:01<tr><td bgcolor=pink align=center>1342<td> <a href=download.php?file=20170831鍵盤指法與中文輸入法.doc>20170831鍵盤指法與中文輸入法.doc</a><td>32256<td>70<td>250<td>2017-09-01 03:11:12</table>
計 30 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=250 order by date desc; ok.