> -Original Message-
> From: Griffiths, Gregory D. /here
> Sent: 12 January 2001 16:08
> To: '[EMAIL PROTECTED]'
> Subject: RE: [PHP-WIN] DB Select Limits
>
>
> does your database support the LIMIT keyword ?
>
> > -Original Message-
By 'Doesn't seem to work' what do you mean?
Does it return no results (and how do you know that this is the case and that
its not some typo elsewhere) or does it give an error message - if so , what?
Tom
Ben Cairns wrote:
> I have a web board script that I need to impose a limit on the database
I have a web board script that I need to impose a limit on the database
select.
I tried using:
SELECT * FROM posts where of_forum='$forum_num' AND POST_ID <= '$upper' AND
POST_ID >= '$lower'
and
SELECT * FROM posts where of_forum='$forum_num' ORDER BY POST_ID desc LIMIT
'$lower','$upper'
$low
