[EMAIL PROTECTED]
> Subject: Re: very newbie insert question
>
> One only needs to specify the column names if and only if there are not
> values, in the correct order, for all of the columns in the table.
>
> That is:
> Create Table foo (
>
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
'$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
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 yo
