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: [EMAIL PROTECTED]> To:
php-db@lists.php.net> Subject: [PHP-DB] 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
