How to sort the recordset chronologically ?

Results 1 to 2 of 2

Thread: How to sort the recordset chronologically ?

  1. #1
    Join Date
    Dec 1969
    Posts
    4

    Default How to sort the recordset chronologically ?

    Hi i am trying to build a guest book and so would like to display the records stored in my database such that the last post is shown first. can you please tell me how to get this done and while writing the sql query, what should the order field be ?<BR>also how do i read only 25 records per page and pass the value of counter to next page ?<BR>also please check out my site http://www.maloyvilla.com and post feedback.<BR>Thanx...

  2. #2
    Join Date
    Dec 1969
    Location
    Los Angeles, CA
    Posts
    21,192

    Default Use SQL

    use the order by clause to order the recordset.<BR><BR><BR>as for the 25 posts per page, try asp101.com and search for paging.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •