Re: Code check please

Your code is [mostly] fine, except for two things: 1. Although you connected to your database with mysql_connect() and mysql_select_db(), you didn't do anything with connection. Try using mysql_query() to send a query to the db, i.e. mysql_query($sql). 2. Your SQL is a bit out of whack. The "SET" clause is used for UPDATEs, not INSERTs. Instead, try: $sql = "INSERT INTO tabell (fornamn, efternamn, email) VALUES (" . "'$fornamn', '$efternamn', '$email');"; Hope that works. J "Andreas Skarin" <sdts@sdts.nu> wrote in message news:3B30C884.5BF6F67E@sdts.nu... > 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 >