Re: Code check please

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"" <rcavanaugh@advolve.com> wrote in message news:BHEPKNPEDJANAMHMBGFJCEGBCKAA.rcavanaugh@advolve.com... > 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 > > > > -- > 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 >