RE: [PHP-DB] mysql error...

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@jdpill.com> To: bastien> php-db@lists.php.net> Subject: [PHP-DB] mysql error...> > this is bugging me to no end (no bastien> pun intended)... I am getting the error:> > invalid query: You have an error in your SQL bastien> syntax; check the manual > that corresponds to your MySQL server version for the right syntax to bastien> > use near 'Condition, ConstructType, BldgDimensions, Stories, > CurrentParking, bastien> MaxParking, P' at line 1> > I cannot find a thing wrong with this... any ideas what may bastien> be the > problem? All the data types are either int(11) or varchar(50).> > John> > bastien> > > INSERT INTO tblBuildings (SiteID, Name, Available, MfgWHSqFt, > OfficeSqFt, TotalSqFt, bastien> MinSqFtAvailable, MaxSqFtAvailable, Condition, > ConstructType, BldgDimensions, Stories, bastien> CurrentParking, MaxParking, > ParkingSurface, PctOccupied, ClearSpan, CeilingMax, PctAC, bastien> PctHeated, > FloorType, Sprinkled, DHDoors, DHSize, GLDoors, GLSize, RRDoors, RRSize, > bastien> CraneNum, CraneSize, RefrigSize) VALUES ('', '[enter building name]', > bastien> 'Y', '', '', '', '', '', '- Select bastien> -', '- Select -', '', '', '', '', '- bastien> > Select -', '', '', '', '', '', '- bastien> Select -', 'Y', '', '', '', '', '', bastien> > '', '', '', '')> > -- > PHP Database Mailing bastien> List (http://www.php.net/)> To unsubscribe, visit: bastien> 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