> -----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-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 12 January 2001 15:59
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: FW: [PHP-WIN] DB Select Limits
> >
> >
> > 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'
> >
> > $lower and $upper are defined from the url.
> >
> > But that doesn't seem to work. Any ideas?
> >
> >
> > -- Ben Cairns - Head Of Technical Operations
> > intasept.COM
> > Tel: 01332 365333
> > Fax: 01332 346010
> > E-Mail: [EMAIL PROTECTED]
> > Web: http://www.intasept.com
> >
> > "MAKING sense of
> > the INFORMATION
> > TECHNOLOGY age
> > @ WORK......"
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
> >
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
