Re: DB Select Limits
| From: | Tom | Date: | Fri, 12 Jan 2001 16:08:19 +0000 |
| Subject: | Re: DB Select Limits | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-4951@lists.php.net to get a copy of this 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
> 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