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

Reply via email to