RE: Last 75 entries from a table

2003-11-06 Thread Barry Byrne
> -Original Message- > From: Mark [mailto:[EMAIL PROTECTED] > Sent: 06 November 2003 13:40 > To: [EMAIL PROTECTED] > Using MySQL 3.23.58, what I want is to select the last 75 entries from a > table. Like so: > > "SELECT article_num FROM $table LIMIT 75"

Re: Last 75 entries from a table

2003-11-06 Thread Mark
- Original Message - From: <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 06, 2003 2:45 PM Subject: Re: Last 75 entries from a table > > "SELECT article_num FROM $table order by \ > article_nu

RE: Last 75 entries from a table

2003-11-06 Thread Dan Greene
you could do select article_num from $table order by article_num desc LIMIT 75 > -Original Message- > From: Mark [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 06, 2003 8:40 AM > To: [EMAIL PROTECTED] > Subject: Last 75 entries from a table > > > Hello,

Re: Last 75 entries from a table

2003-11-06 Thread jeffrey_n_Dyke
t; cc: Subject: Last 75 entries from a table

Last 75 entries from a table

2003-11-06 Thread Mark
Hello, Using MySQL 3.23.58, what I want is to select the last 75 entries from a table. Like so: "SELECT article_num FROM $table LIMIT 75" Except, of course, that this gives me the first 75, whereas I need the last 75. It sounds trivial; and it probably is, but I could not find it. &q