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 (
aid int not null primary key,
last varchar(30),
first varchar(30),
email varchar(60)
);
Right:
Insert Into foo Values (1, '$lastname', '$firstname', '$email');
Insert Into foo (last, first, email) Values ('$lastname', '$firstname',
'$email');
Wrong:
Insert 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 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 it up so the email_address field is the primary key?
HTH.
--Russell
----- Original Message -----
From: "sjs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 7:51 PM
Subject: very newbie insert question
> This is my first script, so I am sorry it is so newbie-ish.
> I think I have the correct script to open the connection, open the
database
> and the table. However, I cannot get the "insert into" to work. I have
read
> several online sources and books, all of which are slightly different. It
is
> not a parse error. Can you help?
>
> Thanks
> SJS
> Script as follows:
>
> <html>
> <head><title>Adding Your Record to the Database</title></head>
> <body>
> <center>
> <?php
> if((!$lastName) || (!firstName) ||(!emailAddress))
> {
> echo "You have not entered all required informaton.<br> Please try again";
> exit;
> }
> $lastName=addslashes($lastName);
> $firstName=addslashes($firstName);
> $email_address=addslashes($email_address);
> @ $db=mysql_pconnect("", "","");
> if (!$db)
> {
> echo "Couldn't connect to the database.<br>If problem persists, please
> contact webmaster";
> exit;
> }
> $db= mysql_select_db("emailDB");
> if (!$db)
> {
> echo "Sorry. Could not retrieve correct database.<br> If problem persists,
> please contact webmaster";
> }
> $sql = "INSERT INTO email_addresses VALUES ('$lastName', '$firstName',
> '$email_address')";
> $result = mysql_query($sql);
> if (!$result)
> {
> echo "<p>Sorry.<br>Your address was not successfully added.<br>If problem
> persists, please contact webmaster.";
> }
> else
> {
> echo "<p>DONE DEAL!";
> }
> ?>
> </body>
> </html>
>
>
>
> ---------------------------------------------------------------------
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
