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
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' ..