Condition is a reserved word in mysql...you will need to change the field name
bastien> Date: Tue, 28 Aug 2007 18:11:20 -0700> From: lists@xxxxxxxxxx> To: php-db@xxxxxxxxxxxxx> Subject: mysql error...> > 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', '', '', '', '', '', > '', '', '', '')> > -- > PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php>
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
