UPDATE syntax for INSERT is allowed in MySQL, so that should not be the
problem as far as you include all fields not having default value, timestamp
type or auto_increment attribute in your statement. What's the error message
if there is any?
lenar
""Rich Cavanaugh"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> You're using UPDATE syntax for your INSERT
>
> try:
>
> $sql = "INSERT INTO tabell (fornamn, efternamn, email) values
('{$fornamn}',
> '{$efternamn}', '{$email}')";
>
> Rich Cavanaugh
>
> -----Original Message-----
> From: Andreas Skarin [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 12:00 PM
> To: PHP General
> Subject: [PHP] Code check please
>
>
> I've tried to get this working for over an hour
> now, and it still won't. I don't even get an error
> message to help me find the problem so I was
> hoping that someone could check my code for me.
>
> I'm fooling around with a basic form that is
> supposed to send one's name, surname and e-mail
> address to "receive.php". "receive.php" is then
> supposed to take the information and add it to a
> table called "tabell" in a database called
> "databas", but it doesn't work. I think there
> might be something wrong with my MySQL query.
>
> - - - - - - - - - - - FORM - - - - - - - - - - - -
> - -
>
> <form action="receive.php" method="post">
> <P>Förnamn:<br>
> <input type="text" name="fornamn"
> size="25"></p>
> <p>Efternamn:<br>
> <input type="text" name="efternamn"
> size="25"></p>
> <p>E-mailadress:<br>
> <input type="text" name="email"
> size="25"></p>
> <input type="submit" name="submit"
> value="Log in">
> </form>
>
> - - - - - - - - - - - - - - - - - - - - - - - - -
> - - -
>
> - - - - - - - - - - - RECEIVE.PHP - - - - - - - -
> - - -
>
> <?php
>
> // connection to MySQL
> $connection = mysql_connect("localhost",
> "username", "password");
> if (!$connection) {
> echo ("<P>Unable to connect to the database
> server at this time.</P>" );
> exit();
> }
>
> //select database
> if (! @mysql_select_db("databas") ) {
> echo ("<P>Unable to locate the database at
> this time.</P>");
> exit();
> }
>
> // MySQL query
> $sql = "INSERT INTO tabell SET" .
> "fornamn ='$fornamn'," .
> "efternamn='$efternamn'," .
> "email='$email';";
> ?>
>
> - - - - - - - - - - - - - - - - - - - - - - - - -
> - - -
>
> Thanks in advance!
>
> // Andreas
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
