mysql error...
| From: | John Pillion | Date: | Wed, 29 Aug 2007 01:11:20 +0000 |
| Subject: | mysql error... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43957@lists.php.net to get a copy of this message | ||
this is bugging me to no end (no pun intended)... I am getting the error:
invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, ConstructType, BldgDimensions, Stories, CurrentParking, MaxParking, P' at line 1
I cannot find a thing wrong with this... any ideas what may be the problem? All the data types are either int(11) or varchar(50).
John
INSERT INTO tblBuildings (SiteID, Name, Available, MfgWHSqFt, OfficeSqFt, TotalSqFt, MinSqFtAvailable, MaxSqFtAvailable, Condition, ConstructType, BldgDimensions, Stories, CurrentParking, MaxParking, ParkingSurface, PctOccupied, ClearSpan, CeilingMax, PctAC, PctHeated, FloorType, Sprinkled, DHDoors, DHSize, GLDoors, GLSize, RRDoors, RRSize, CraneNum, CraneSize, RefrigSize) VALUES ('', '[enter building name]', 'Y', '', '', '', '', '', '- Select -', '- Select -', '', '', '', '', '- Select -', '', '', '', '', '', '- Select -', 'Y', '', '', '', '', '', '', '', '', '')