> -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"
- 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
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,
t; cc:
Subject: Last 75 entries from a table
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