I always use
INSERT INTO table SET field1='value', field2='value', etc...
If I don't specify fields like an auto-incrementing number, it is filled in
automatically.
- Jonathan
-Original Message-
From: sjs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 5:51 PM
To: [EMAIL
Into foo Values ('$lastname', '$firstname', '$email');
..chris
- Original Message -
From: Russell Miller [EMAIL PROTECTED]
To: sjs [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 03, 2001 7:53 PM
Subject: Re: very newbie insert question
I did not see the full schema
I did not see the full schema so I can't give you a definite answer.
However, your syntax is wrong:
INSERT INTO email_addresses (last_name, first_name, email_address) VALUES
($lastname, $firstname, $email_address);
For each value you specify, you also have to specify a column name.
Did you set
]
To: sjs [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 03, 2001 7:53 PM
Subject: Re: very newbie insert question
I did not see the full schema so I can't give you a definite answer.
However, your syntax is wrong:
INSERT INTO email_addresses (last_name, first_name, email_address