SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: 10 latest

  1. #1
    Non-Member MrLister's Avatar
    Join Date
    Feb 2001
    Posts
    108
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    10 latest

    I have a row called essays_id and there's 25 ids. and i'm trying to get the last 10 so that would be from 15-25. if there were 36 it would be 26-36. what kind of query do i set up to do this? so it shows the last 10 essays_title submitted.

  2. #2
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Something like so:

    SELECT *
    FROM tableName
    ORDER BY essays_id DESC
    LIMIT 10


Bookmarks

Posting Permissions

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