hi, MATCH is a reserved word. Try to rename your table.
HTH. Anton Tichawa. > -----Original Message----- > From: Chris Aitken [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 25, 2001 1:09 PM > To: [EMAIL PROTECTED] > Subject: Weird Error Inserting > > > ------------------------------------ > > Unable to insert [ > insert into match (league_id,round_id,team_id_1,team_id_2) > VALUES ('1','3','2','3') > ]: You have an error in your SQL syntax near 'match > (league_id,round_id,team_id_1,team_id_2) VALUES > ('1','3','2','3')' at line 1. > > ------------------------------------ > > I have the above weird error when im trying to insert into a > database. No > matter what I try, I cannot seem to find the error. Any > suggestions that > im missing here. Its driving me nuts. the syntax seems to be > okay as far > as I can tell. > > > Any suggestions here greatly appreciated. > > > > > Chris > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
