How come float types takes string

[iffoiffy]

Hi,

I have type float for retail price. Follwing sql seems correct

$sqlstring= "update products set brand = '$brand' , brand_id = '$brand_id' , model = '$model' , description = '$description' , retail_price = $retail_price where product_id ='$prod_id'";

But I noticed even if I put "'" around retail price it takes it and updates, shouldn't it gives me an error as i am trying to put string in float type


$sqlstring= "update products set brand = '$brand' , brand_id = '$brand_id' , model = '$model' , description = '$description' , retail_price = '$retail_price' where product_id ='$prod_id'";

Thanks

 

[r937]

yes, it should give an error, but it doesn't

mysql is very non-standard in several areas, and this is one of them

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)