<%
ID=POS_ID
rs.close
sql = "SELECT * FROM BKK_PICTURE WHERE (sub_id = '"&request("id")&"') ORDER BY pic_name"
rs.open sql,conn,3,1
for i=1 to rs.recordcount
<!-- Thumbnail=C1.FindPathFile("D:\FAD\fad_bkk\Photo\ARC\"&rs("PIC_NAME")&"","..\Photo\ARC\",Thumbnail) -->
%>
และเมื่อเลือก List/menu เรียกตามวันที่
Code (ASP)
<%
ID=POS_ID
rs.close
sql = "SELECT * FROM BKK_PICTURE WHERE (sub_id = '"&request("id")&"') ORDER BY pic_name DESC"
rs.open sql,conn,3,1
for i=1 to rs.recordcount
<!-- Thumbnail=C1.FindPathFile("D:\FAD\fad_bkk\Photo\ARC\"&rs("PIC_NAME")&"","..\Photo\ARC\",Thumbnail) -->
%>
<%
ID=POS_ID
rs.close
sql = "SELECT * FROM BKK_PICTURE WHERE (sub_id = '"&request("id")&"') ORDER BY pic_name"
rs.open sql,conn,3,1
for i=1 to rs.recordcount
<!-- Thumbnail=C1.FindPathFile("D:\FAD\fad_bkk\Photo\ARC\"&rs("PIC_NAME")&"","..\Photo\ARC\",Thumbnail) -->
%>
Code (ASP)
<%
ID=POS_ID
rs.close
sql = "SELECT * FROM BKK_PICTURE WHERE (sub_id = '"&request("id")&"') ORDER BY pic_name DESC"
rs.open sql,conn,3,1
for i=1 to rs.recordcount
<!-- Thumbnail=C1.FindPathFile("D:\FAD\fad_bkk\Photo\ARC\"&rs("PIC_NAME")&"","..\Photo\ARC\",Thumbnail) -->
%>