湖濱散記部落格的樹心幽徑(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>2192<td> <a href=download.php?file=A10.png>A10.png</a><td>417185<td>70<td>271<td>2019-12-01 02:56:54<tr><td bgcolor=pink align=center>2191<td> <a href=download.php?file=A9.png>A9.png</a><td>265249<td>70<td>271<td>2019-12-01 01:46:49<tr><td bgcolor=pink align=center>2190<td> <a href=download.php?file=A8.png>A8.png</a><td>309633<td>70<td>271<td>2019-12-01 01:01:20<tr><td bgcolor=pink align=center>2189<td> <a href=download.php?file=A7.png>A7.png</a><td>49836<td>70<td>271<td>2019-12-01 01:01:20<tr><td bgcolor=pink align=center>2188<td> <a href=download.php?file=A6.png>A6.png</a><td>69110<td>70<td>271<td>2019-12-01 01:01:19<tr><td bgcolor=pink align=center>2186<td> <a href=download.php?file=A5.png>A5.png</a><td>105412<td>70<td>271<td>2019-11-30 02:43:04<tr><td bgcolor=pink align=center>2185<td> <a href=download.php?file=A4.png>A4.png</a><td>150598<td>70<td>271<td>2019-11-30 02:43:04<tr><td bgcolor=pink align=center>2184<td> <a href=download.php?file=A3.png>A3.png</a><td>467104<td>70<td>271<td>2019-11-30 02:43:04<tr><td bgcolor=pink align=center>2183<td> <a href=download.php?file=A2.png>A2.png</a><td>125051<td>70<td>271<td>2019-11-30 02:43:04<tr><td bgcolor=pink align=center>2182<td> <a href=download.php?file=A1.png>A1.png</a><td>39803<td>70<td>271<td>2019-11-30 02:43:03</table>
計 10 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=271 order by date desc; ok.