Mysql Problem

[bcode]

It is giving me an Error in your SQL syntax near 'float,rentprice) Values ('

but I can't see where the problem is

 

 

$sql = "INSERT INTO Listings "; 
			$sql .= "(propName, price, description, type, city, state, image1, authorized,country, address, zipcode, featured, ownerID,ownerEmail,bedrooms,bathrooms,resortName,deed,cc4digit,ccexp,unitNum,float,rentprice)";
			$sql .= " VALUES ('$propName','$price','$description','$type','$city','$state','$imagepath','no','$country','$address','$zipcode','$featured','$ownerid','$email','$bed','$bath','$resortname','$deed','$CC4','$CCX','$unit','$float','$rentalprice')";

[premiso]

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

 

Float is a reserved word. Either enclose it in backticks (not preferred) or change the name to a non-reserved word (preferred).

[bcode]

Awesome i did not know that thank you i just changed the name and it worked i was looking at it for so long thinking I miss spelled a word.