Re: Searching within a range
| From: | Jason Wong | Date: | Fri, 28 Jun 2002 13:35:03 +0000 |
| Subject: | Re: Searching within a range | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-104312@lists.php.net to get a copy of this message | ||
On Friday 28 June 2002 19:15, Bård Tommy Nilsen wrote:
> I want to search within a result from a query
Did you really mean that, or did you mean you want a query which returns
results within ...
> A specific range (price)
? If the latter then ...
> For example.
>
>
> I want to display only the articles that cost between 0-50>
select * from table where price > 0 AND price < 50;
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Barach's Rule:
An alcoholic is a person who drinks more than his own physician.
*/