Chris
Are those columns really character types, or integers ?
The values you list are quoted, which suggests they're character based, but
'id' suggests integers, ie.
insert into match (league_id,round_id,team_id_1,team_id_2) VALUES (1,3,2,3);
Phil
----- Original Message -----
From: "Chris Aitken" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 12:08 PM
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
