湖濱散記部落格的樹心幽徑(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>2082<td> <a href=download.php?file=audacity-2.png>audacity-2.png</a><td>219774<td>70<td>241<td>2019-10-03 21:54:07<tr><td bgcolor=pink align=center>2081<td> <a href=download.php?file=audacity-1.png>audacity-1.png</a><td>132103<td>70<td>241<td>2019-10-03 21:54:06<tr><td bgcolor=pink align=center>2080<td> <a href=download.php?file=台灣騷蟬.mp3>台灣騷蟬.mp3</a><td>388284<td>70<td>241<td>2019-10-03 21:47:59<tr><td bgcolor=pink align=center>2079<td> <a href=download.php?file=山羌.mp3>山羌.mp3</a><td>370311<td>70<td>241<td>2019-10-03 21:47:59<tr><td bgcolor=pink align=center>2078<td> <a href=download.php?file=大冠鷲.mp3>大冠鷲.mp3</a><td>316395<td>70<td>241<td>2019-10-03 21:46:58<tr><td bgcolor=pink align=center>1187<td> <a href=download.php?file=許雅琁.aup>許雅琁.aup</a><td>46093<td>70<td>241<td>2016-06-19 21:49:05<tr><td bgcolor=pink align=center>1174<td> <a href=download.php?file=哺-白面鼯鼠.mp3>哺-白面鼯鼠.mp3</a><td>235729<td>70<td>241<td>2016-06-19 21:09:13<tr><td bgcolor=pink align=center>1173<td> <a href=download.php?file=哺-台灣獼猴.mp3>哺-台灣獼猴.mp3</a><td>163422<td>70<td>241<td>2016-06-19 21:09:13<tr><td bgcolor=pink align=center>1176<td> <a href=download.php?file=哺-錢鼠.mp3>哺-錢鼠.mp3</a><td>193515<td>70<td>241<td>2016-06-19 21:09:13<tr><td bgcolor=pink align=center>1177<td> <a href=download.php?file=鳥-大卷尾.mp3>鳥-大卷尾.mp3</a><td>496535<td>70<td>241<td>2016-06-19 21:09:13<tr><td bgcolor=pink align=center>1171<td> <a href=download.php?file=哺-大赤鼯鼠.mp3>哺-大赤鼯鼠.mp3</a><td>328097<td>70<td>241<td>2016-06-19 21:09:13<tr><td bgcolor=pink align=center>1170<td> <a href=download.php?file=昆蟲-陽明山暮蟬.mp3>昆蟲-陽明山暮蟬.mp3</a><td>331023<td>70<td>241<td>2016-06-19 21:09:13<tr><td bgcolor=pink align=center>1175<td> <a href=download.php?file=哺-赤腹松鼠.mp3>哺-赤腹松鼠.mp3</a><td>243670<td>70<td>241<td>2016-06-19 21:09:13</table>
計 13 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=241 order by date desc; ok.