湖濱散記部落格的樹心幽徑(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>1266<td> <a href=download.php?file=20170111access進出excel.doc>20170111access進出excel.doc</a><td>22528<td>70<td>243<td>2017-01-10 20:55:35<tr><td bgcolor=pink align=center>1255<td> <a href=download.php?file=20170104日期時間函數.xls>20170104日期時間函數.xls</a><td>27648<td>70<td>243<td>2017-01-03 21:03:26<tr><td bgcolor=pink align=center>1250<td> <a href=download.php?file=20161228統計圖.xls>20161228統計圖.xls</a><td>38912<td>70<td>243<td>2016-12-27 20:52:35<tr><td bgcolor=pink align=center>1248<td> <a href=download.php?file=20161221月曆製作.xls>20161221月曆製作.xls</a><td>47104<td>70<td>243<td>2016-12-20 20:52:48<tr><td bgcolor=pink align=center>1246<td> <a href=download.php?file=20161214推算天干地支農曆年b.xls>20161214推算天干地支農曆年b.xls</a><td>30720<td>70<td>243<td>2016-12-13 21:10:06<tr><td bgcolor=pink align=center>1240<td> <a href=download.php?file=20161207成績表.xls>20161207成績表.xls</a><td>27136<td>70<td>243<td>2016-12-06 20:57:31<tr><td bgcolor=pink align=center>1237<td> <a href=download.php?file=20161130Excel初步.xls>20161130Excel初步.xls</a><td>28160<td>70<td>243<td>2016-11-29 20:55:39<tr><td bgcolor=pink align=center>1232<td> <a href=download.php?file=20161123餐一投影片.ppt>20161123餐一投影片.ppt</a><td>176640<td>70<td>243<td>2016-11-22 20:54:30<tr><td bgcolor=pink align=center>1220<td> <a href=download.php?file=20161116條碼字型與EXCEL工作表及方程式編輯器.doc>20161116條碼字型與EXCEL工作表及方程式編輯器.doc</a><td>89088<td>70<td>243<td>2016-11-15 20:52:54<tr><td bgcolor=pink align=center>1210<td> <a href=download.php?file=20161109餐管一表格編輯.doc>20161109餐管一表格編輯.doc</a><td>68096<td>70<td>243<td>2016-11-08 20:57:33<tr><td bgcolor=pink align=center>1206<td> <a href=download.php?file=20161102文字方塊文字藝術師圖浮水印.doc>20161102文字方塊文字藝術師圖浮水印.doc</a><td>137728<td>70<td>243<td>2016-11-01 21:53:05<tr><td bgcolor=pink align=center>1203<td> <a href=download.php?file=20161026軟用丙檢術科第5題合併列印.doc>20161026軟用丙檢術科第5題合併列印.doc</a><td>131072<td>70<td>243<td>2016-10-25 21:54:52<tr><td bgcolor=pink align=center>1200<td> <a href=download.php?file=20161019軟用丙檢術科第7題合併列印.doc>20161019軟用丙檢術科第7題合併列印.doc</a><td>121856<td>70<td>243<td>2016-10-18 22:00:46<tr><td bgcolor=pink align=center>1197<td> <a href=download.php?file=20161005檢定7文書排版操作.doc>20161005檢定7文書排版操作.doc</a><td>33280<td>70<td>243<td>2016-10-04 21:59:05<tr><td bgcolor=pink align=center>1196<td> <a href=download.php?file=20161005檢定7文書排版結果.doc>20161005檢定7文書排版結果.doc</a><td>33792<td>70<td>243<td>2016-10-04 21:59:05<tr><td bgcolor=pink align=center>1194<td> <a href=download.php?file=20160921電腦軟體應用丙級檢定術科第1題.doc>20160921電腦軟體應用丙級檢定術科第1題.doc</a><td>26624<td>70<td>243<td>2016-09-20 21:34:33<tr><td bgcolor=pink align=center>1193<td> <a href=download.php?file=20160907字型與段落設定.doc>20160907字型與段落設定.doc</a><td>30208<td>70<td>243<td>2016-09-06 22:09:19</table>
計 17 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=243 order by date desc; ok.