FW: [PHP-WIN] DB Select Limits
| From: | Gregory_Griffiths at cargill dot com | Date: | Fri, 12 Jan 2001 16:07:20 +0000 |
| Subject: | FW: [PHP-WIN] DB Select Limits | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4952@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Griffiths, Gregory D. /here
> Sent: 12 January 2001 16:08
> To: 'BenC@intasept.com'
> Subject: RE: [PHP-WIN] DB Select Limits
>
>
> does your database support the LIMIT keyword ?
>
> > -----Original Message-----
> > From: BenC@intasept.com [mailto:BenC@intasept.com]
> > Sent: 12 January 2001 15:59
> > To: php-windows@lists.php.net
> > Cc: BenC@intasept.com
> > 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: BenC@intasept.com
> > 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: php-windows-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-windows-help@lists.php.net
> > To contact the list administrators, e-mail:
> > php-list-admin@lists.php.net
> >
> >
>