[RESOLVED] LIMIT statement

[msimonds]

I got this to work:

$query = "SELECT blog_id, title, entry, DATE_FORMAT(date_entered, '%M %e, %Y') AS formatted_date
                                  FROM blog_entries ORDER BY blog_id DESC LIMIT 3";

to show the latest 3 artlces on the home page of a script I am writing!

BUT

I am trying to write the same query for the archive page which would show all but the latest and I cannot get it to work, i dont know the correct verbage. This query, as everyone knows, will get it all, how can I LIMIT this to show all but the first 3 ordered by blog_id

$query = "SELECT blog_id, title, entry, DATE_FORMAT(date_entered, '%M %e, %Y') AS formatted_date
                                  FROM blog_entries ORDER BY blog_id DESC";

Thanks
Mike

[konrad]

Here's a note from MySQL Reference

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;

So the query might look like

  $query = "SELECT blog_id, title, entry, DATE_FORMAT(date_entered, '%M %e, %Y') AS formatted_date
                                  FROM blog_entries ORDER BY blog_id DESC LIMIT 3, 99999999999999"; 

[msimonds]

that was it konrad, Thanks man!!!!