SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    May 2004
    Location
    nyc
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    using LIMIT In query

    I'm using the following query to display the 8 most recent entries.

    mysql_query("SELECT * FROM journal_comment ORDER BY id DESC LIMIT 8");

    How would I configure LIMIT to display 8 entries before those?

  2. #2
    SitePoint Zealot manoloweb's Avatar
    Join Date
    Aug 2003
    Location
    Mexico
    Posts
    148
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SELECT * FROM journal_comment ORDER BY id DESC LIMIT 8,8

  3. #3
    SitePoint Member
    Join Date
    May 2004
    Location
    nyc
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by manoloweb
    SELECT * FROM journal_comment ORDER BY id DESC LIMIT 8,8
    thank you!


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
  •