湖濱散記部落格的樹心幽徑(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>1832<td> <a href=download.php?file=20190215NetbootFc28_4.png>20190215NetbootFc28_4.png</a><td>1208463<td>70<td>263<td>2019-02-15 00:52:18<tr><td bgcolor=pink align=center>1831<td> <a href=download.php?file=20190214fc28NetBootCsPC8.png>20190214fc28NetBootCsPC8.png</a><td>163940<td>70<td>263<td>2019-02-14 00:01:25<tr><td bgcolor=pink align=center>1830<td> <a href=download.php?file=20190213NetBootFC28-CSRoom-1.png>20190213NetBootFC28-CSRoom-1.png</a><td>262664<td>70<td>263<td>2019-02-13 01:21:13<tr><td bgcolor=pink align=center>1825<td> <a href=download.php?file=20190208dhcp-tftp-fc28NetbootB.png>20190208dhcp-tftp-fc28NetbootB.png</a><td>749138<td>70<td>263<td>2019-02-08 07:25:32<tr><td bgcolor=pink align=center>1824<td> <a href=download.php?file=20190208pxe-dchp-tftp-netboot-fc28-3.png>20190208pxe-dchp-tftp-netboot-fc28-3.png</a><td>745846<td>70<td>263<td>2019-02-07 22:40:29<tr><td bgcolor=pink align=center>1823<td> <a href=download.php?file=20190207NetBootFromFc28-2.png>20190207NetBootFromFc28-2.png</a><td>737637<td>70<td>263<td>2019-02-06 23:01:08<tr><td bgcolor=pink align=center>1822<td> <a href=download.php?file=20190207netbootfromfc28server.png>20190207netbootfromfc28server.png</a><td>965358<td>70<td>263<td>2019-02-06 20:39:39<tr><td bgcolor=pink align=center>1820<td> <a href=download.php?file=20190126FC28ipxeNetboot_client.png>20190126FC28ipxeNetboot_client.png</a><td>558788<td>70<td>263<td>2019-01-25 19:46:19<tr><td bgcolor=pink align=center>1819<td> <a href=download.php?file=20190125234455ipxeBootfc28.png>20190125234455ipxeBootfc28.png</a><td>94388<td>70<td>263<td>2019-01-25 10:48:57</table>
計 9 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=263 order by date desc; ok.