yeah, i would go with Rick on this.
however, the reason i think it's not working is because it's comparing the
contents alphabetically ie. 2 is greater than 1 but is also greater than
10, 19 etc etc alphabetically, just as anything beginning with b
is greater than a and also aazzxsd.
if you absolutely must continue to use the varchar system, then do a check
on the string length first, and then if they are the same length do a
check.
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2002 20:47
To: 'Mike'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] numeric string problem
The question is: why use varchar? Why not use INT, then format to includes
commas when displaying?
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 3:38 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] numeric string problem
Hi,
I am using VARCHAR for price column : 600,000 700,000 etc
when I use : PRICERANGE='$Price'
it works fine except when the $Price moves to 7 digit as 1,000,000
in other words the less than does not work when comparing 6 digit and 7
digit figures
I am not sure how to compensate for this.
Thanks
Mike
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.319 / Virus Database: 178 - Release Date: 28/01/02
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.319 / Virus Database: 178 - Release Date: 28/01/02
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php