湖濱散記部落格的樹心幽徑(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>1268<td> <a href=download.php?file=20170116MS-access.doc>20170116MS-access.doc</a><td>25088<td>70<td>245<td>2017-01-15 20:57:31<tr><td bgcolor=pink align=center>1257<td> <a href=download.php?file=20170109日期時間函數.xls>20170109日期時間函數.xls</a><td>25088<td>70<td>245<td>2017-01-08 20:53:18<tr><td bgcolor=pink align=center>1241<td> <a href=download.php?file=20161212天干地支日期函數.xls>20161212天干地支日期函數.xls</a><td>28672<td>70<td>245<td>2016-12-11 20:56:20<tr><td bgcolor=pink align=center>1238<td> <a href=download.php?file=20161205EXcel成績表.xls>20161205EXcel成績表.xls</a><td>25088<td>70<td>245<td>2016-12-04 20:54:39<tr><td bgcolor=pink align=center>1233<td> <a href=download.php?file=20161128Excel.xls>20161128Excel.xls</a><td>24576<td>70<td>245<td>2016-11-27 20:55:16<tr><td bgcolor=pink align=center>1221<td> <a href=download.php?file=20161121簡報製作.ppt>20161121簡報製作.ppt</a><td>76288<td>70<td>245<td>2016-11-20 20:56:08<tr><td bgcolor=pink align=center>1214<td> <a href=download.php?file=20161114條碼字型與方程式編輯器.doc>20161114條碼字型與方程式編輯器.doc</a><td>60416<td>70<td>245<td>2016-11-13 20:54:37<tr><td bgcolor=pink align=center>1207<td> <a href=download.php?file=20161107表格編輯.doc>20161107表格編輯.doc</a><td>52736<td>70<td>245<td>2016-11-06 20:52:24<tr><td bgcolor=pink align=center>1204<td> <a href=download.php?file=20161031文字方塊圖片浮水印.doc>20161031文字方塊圖片浮水印.doc</a><td>186880<td>70<td>245<td>2016-10-30 21:59:01<tr><td bgcolor=pink align=center>1201<td> <a href=download.php?file=20161024合併列印.doc>20161024合併列印.doc</a><td>134656<td>70<td>245<td>2016-10-23 21:55:46<tr><td bgcolor=pink align=center>1198<td> <a href=download.php?file=20161017段落與表格內對齊項目符號框線網底.doc>20161017段落與表格內對齊項目符號框線網底.doc</a><td>43520<td>70<td>245<td>2016-10-16 21:59:26</table>
計 11 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=245 order by date desc; ok.