Re: [PHP-DB] Comparison with formatted numbers

2002-07-30 Thread leo g. divinagracia iii
try the good ol' SETTYPE function to set the variable type from string to numeric and visa versa... http://www.php.net/manual/en/function.settype.php Terry Romine wrote: > I've run into a sticky case where my query is failing (PHP4.x/MySQL). > > I have a table where the price value is imported

[PHP-DB] Comparison with formatted numbers

2002-07-30 Thread Terry Romine
I've run into a sticky case where my query is failing (PHP4.x/MySQL). I have a table where the price value is imported from an external source, so I can't change it on the fly, and they embed thousands seperators (in my case ','). When I try to do a query such as ".. where price <= '25' ..