湖濱散記部落格的樹心幽徑(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>891<td> <a href=download.php?file=20130121WordExceL操作題目.doc>20130121WordExceL操作題目.doc</a><td>294400<td>70<td>226<td>2014-07-02 21:32:05<tr><td bgcolor=pink align=center>890<td> <a href=download.php?file=20130105WordExceL操作題目.doc>20130105WordExceL操作題目.doc</a><td>295424<td>70<td>226<td>2014-07-02 21:30:42<tr><td bgcolor=pink align=center>889<td> <a href=download.php?file=20130104九九表.xls>20130104九九表.xls</a><td>24576<td>70<td>226<td>2014-07-02 21:27:58</table>
計 3 筆資料!
<hr color=red> select id,owner_id,album_id,date,file_name,file_size from lt_gallery_resources where album_id=226 order by date desc; ok.