湖濱散記部落格的樹心幽徑(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>1189<td> <a href=download.php?file=陳嘉翎.aup>陳嘉翎.aup</a><td>46472<td>70<td>242<td>2016-06-19 21:51:09<tr><td bgcolor=pink align=center>1188<td> <a href=download.php?file=王明心.aup>王明心.aup</a><td>45164<td>70<td>242<td>2016-06-19 21:49:16<tr><td bgcolor=pink align=center>1185<td> <a href=download.php?file=1185-王靜柔.WAV.aup>1185-王靜柔.WAV.aup</a><td>25631<td>70<td>242<td>2016-06-19 21:47:50<tr><td bgcolor=pink align=center>1183<td> <a href=download.php?file=葉俐君.aup.aup>葉俐君.aup.aup</a><td>45781<td>70<td>242<td>2016-06-19 21:47:45<tr><td bgcolor=pink align=center>1182<td> <a href=download.php?file=1182-吳秋月wav.aup>1182-吳秋月wav.aup</a><td>46110<td>70<td>242<td>2016-06-19 21:47:18<tr><td bgcolor=pink align=center>1181<td> <a href=download.php?file=吳秋月wav.aup>吳秋月wav.aup</a><td>46110<td>70<td>242<td>2016-06-19 21:47:04</table>
計 6 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=242 order by date desc; ok.