RE: [PHP] Code check please

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:sdts@sdts.nu] 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&ouml;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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net