CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. May 16th, 2007, 08:14 PM #1
    Andrex's Avatar
    Andrex
    Andrex is offline Member
    Join Date
    Feb 2003
    Location
    AR
    Posts
    228

    MySQL 4: Select last 100 records from table

    I have a table in which items are constantly added with a date and time indicator, but I need to retrieve from it only the last 100 items added.

    Any help will be greatly appreciated, thanks!
    DivXLand.org
    Reply With Quote Reply With Quote
  2. May 16th, 2007, 11:04 PM #2
    Shuja Ali's Avatar
    Shuja Ali
    Shuja Ali is offline Elite Member Power Poster
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    Re: MySQL 4: Select last 100 records from table

    PHP Code:
    Select * From TABLENAME Order BY DateField Desc Limit 100 
    Reply With Quote Reply With Quote
  3. May 17th, 2007, 01:37 PM #3
    Andrex's Avatar
    Andrex
    Andrex is offline Member
    Join Date
    Feb 2003
    Location
    AR
    Posts
    228

    Re: MySQL 4: Select last 100 records from table

    Thanks!
    DivXLand.org
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured