> This may sound like an odd question and something that I should know,
> but .......
> I need to display results by amount - for example, for all properties
> which are either or between 450,000 and 500,000 (For example) - how
> using PHP and MySQL do I get it to display 450,000, 50,000 and all
> inbetween ???  I can easily get it to display one or the other, but
> it is a search which is based on cost of property.  How will I format
> the MySQL query to get it to do this?

You can do something like:

  SELECT * FROM property WHERE price BETWEEN 450000 AND 500000;

Jason Wong -> Gremlins Associates -> www.gremlins.com.hk

Skill without imagination is craftsmanship and gives us many useful 
objects such as wickerwork picnic baskets. Imagination without skill 
gives us modern art. -- Tom Stoppard

PHP Database 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]

Reply via email to