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", "199999" 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

Reply via email to