From: "Jason Wong" <[EMAIL PROTECTED]>
> select * from table where price > 0 AND price < 50;
SELECT * FROM table WHERE price BETWEEN 0 AND 50;
Same thing, easier to read (assuming MySQL, don't know if it works on
others).
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To
>I want to search within a result from a query
>A specific range (price)
If that's what you really want, then you need to save the results of your
first query into a table that you can re-query at a later date. Run a cron
job to delete old tables.
If your query is:
SELECT * FROM main WHERE pric
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 th
3 matches
Mail list logo
