湖濱散記部落格的樹心幽徑(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>1462<td> <a href=download.php?file=20171221重修作業6_ACCESS資料庫操作.doc>20171221重修作業6_ACCESS資料庫操作.doc</a><td>139776<td>70<td>255<td>2017-12-21 04:19:43<tr><td bgcolor=pink align=center>1461<td> <a href=download.php?file=20171220重修作業5.txt>20171220重修作業5.txt</a><td>1282<td>70<td>255<td>2017-12-20 04:34:54<tr><td bgcolor=pink align=center>1459<td> <a href=download.php?file=20171219重修作業四.ppt>20171219重修作業四.ppt</a><td>61952<td>70<td>255<td>2017-12-19 04:22:04<tr><td bgcolor=pink align=center>1455<td> <a href=download.php?file=20171218重修3電腦繪圖.ufo>20171218重修3電腦繪圖.ufo</a><td>631296<td>70<td>255<td>2017-12-18 04:42:10<tr><td bgcolor=pink align=center>1440<td> <a href=download.php?file=20171213重修作業2.xls>20171213重修作業2.xls</a><td>27136<td>70<td>255<td>2017-12-13 04:38:10<tr><td bgcolor=pink align=center>1439<td> <a href=download.php?file=20171212重修1.doc>20171212重修1.doc</a><td>30208<td>70<td>255<td>2017-12-12 04:41:57</table>
計 6 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=255 order by date desc; ok.