RE: [PHP-DB] Database help needed
| From: | Beau Lebens | Date: | Thu, 22 Nov 2001 05:14:28 +0000 |
| Subject: | RE: [PHP-DB] Database help needed | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14523@lists.php.net to get a copy of this message | ||
should be able to do something like
SELECT whatever FROM whereever WHERE value<='500000' AND value>='450000'
is that what you are looking for?
// -----Original Message-----
// From: Chris Payne [mailto:chris@planetoxygene.com]
// Sent: Thursday, 22 November 2001 3:11 PM
// To: php-db@lists.php.net
// Subject: [PHP-DB] Database help needed
//
//
// Hi there everyone,
//
// 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?
//
// Please help a little english guy lost in the USA :-)
//
// Thank you everyone, it's very appreciated.
//
// Regards
//
// Chris
//
// www.planetoxygene.com
//