湖濱散記部落格的樹心幽徑(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>1898<td> <a href=download.php?file=20190429HtmlCssDivTable2.png>20190429HtmlCssDivTable2.png</a><td>215446<td>70<td>257<td>2019-04-29 03:59:07<tr><td bgcolor=pink align=center>1896<td> <a href=download.php?file=20190429htmlcss-g1.png>20190429htmlcss-g1.png</a><td>155734<td>70<td>257<td>2019-04-29 02:07:34<tr><td bgcolor=pink align=center>1897<td> <a href=download.php?file=cat.png>cat.png</a><td>106628<td>70<td>257<td>2019-04-29 02:07:34<tr><td bgcolor=pink align=center>1895<td> <a href=download.php?file=20190429htmlmap-g2.png>20190429htmlmap-g2.png</a><td>199612<td>70<td>257<td>2019-04-29 02:07:33<tr><td bgcolor=pink align=center>1885<td> <a href=download.php?file=20190422htmlcssjs.png>20190422htmlcssjs.png</a><td>175508<td>70<td>257<td>2019-04-22 04:06:09<tr><td bgcolor=pink align=center>1884<td> <a href=download.php?file=20190422htmltable.png>20190422htmltable.png</a><td>117433<td>70<td>257<td>2019-04-22 03:07:08<tr><td bgcolor=pink align=center>1533<td> <a href=download.php?file=20180525jscat.png>20180525jscat.png</a><td>165388<td>70<td>257<td>2018-05-25 03:05:54<tr><td bgcolor=pink align=center>1515<td> <a href=download.php?file=20180504htmlTableJS.png>20180504htmlTableJS.png</a><td>151071<td>70<td>257<td>2018-05-04 03:00:15<tr><td bgcolor=pink align=center>1511<td> <a href=download.php?file=20180420html1.png>20180420html1.png</a><td>124075<td>70<td>257<td>2018-04-20 02:04:54</table>
計 9 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=257 order by date desc; ok.