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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
