꾸벅...

음..저희 사무실 홈페이지가 asp가 사용되었는데....
고객들이..사진을 주문하는 메뉴에서 정렬이..엉망이여서...어찌 고쳐 볼까 하는데..
어떻게 짰는지..날짜순도 아니고 고객 이름 가나다 순도 아니고....ㅡ_ㅡ;;;
제가 프로그램을 거의 몰라서 간단한것 찾아서 고치지만 이간 무리네요...

날짜순으로 주문한 목록을 정렬하려면 어찌해야 하나요?
소스만 가르쳐 주시면 제가 끼워맞춰보도록 하죠..
   <% 'response.expires=0
                                                        
                                                        if request("page")="" then
                                                                page=1
                                                        else
                                                                page=request("page")
                                                                nowpage=request("nowpage")
                                                        end if

                                                %>
                        <!--#include file="../inc/oledbopen.inc"-->
                        <%
                                                        sql=" select m.p_id,m.p_name,m.p_phone,m.p_email,a.b_userid,a.b_number,a.b_date from photo_member m,photo_albumbuy a "
                                                        sql= sql & " where m.p_id=a.b_userid "
                                                        
                                                        set rs=server.createobject("adodb.recordset")
                                                        rs.open sql,dbcon,1
                                                        
                                                        rs.pagesize=10        
                                                        totalcount=rs.recordcount
                                                        pagenonum=10
                                                        currentpageno=cint(fix((pageno-1)/pagenonum))*pagenonum+1
                                                %>

여기를 어찌 고치면 될 것 같은데..


감사합니다...




(__)