I get an error but i dont know why..

[postbil.com]

Hello phpfreaks..

 

I had some problems with a activation script.. But I do not see the problem.. the error come from the mysql_query(), so I will mean it is my sql code there is the problem but I dont see why...

 

<?php

// Make the connection to the database

    include ('../DB/db.connect.inc.php');

   

 

      $userid = $_GET['userid'];

      $active = $_GET['actcode'];

     

      $query = "INSERT INTO site_user

                (active)

            VALUES

                ($active)

 

        WHERE user_id =" . $userid;

 

             

      mysql_query($query, $conn) or die ('Error: Der er opstået en database fejl, og det var derfor ikke muligt at gennemføre aktiveringen'); // this is the error I get

?>

 

Someone please help me!!

 

postbil.com

[trq]

And the error is?

[postbil.com]

I dont know what the problem is but, I get the error from the mysql_error(), Why can that be?

[rajivgonsalves]

your trying to insert with a where did you mean to update a user_id ?

 

 

[trq]

I dont know what the problem is but, I get the error from the mysql_error(), Why can that be?

 

Yeah, and its usually helpful to tell us what that error is.

[postbil.com]

Okay .. The error is just a message on a it was not possible to send data to the database.

The idea behind the code was that I would make "active" to 1, and then use $ userid to ensure that it is the right user who is enabled.

[rajivgonsalves]

your could should be

 

<?php
// Make the connection to the database
    include ('../DB/db.connect.inc.php');
   

      $userid = $_GET['userid'];
      $active = $_GET['actcode'];
     
      $query = "UPDATE `site_user`
                set `active` =  $active
         WHERE user_id =" . $userid;

               
      mysql_query($query, $conn) or die ('Error: Der er opstået en database fejl, og det var derfor ikke muligt at gennemføre aktiveringen'); // this is the error I get
?> 

[trq]

Okay .. The error is just a message on a it was not possible to send data to the database.

The idea behind the code was that I would make "active" to 1, and then use $ userid to ensure that it is the right user who is enabled.

 

You still don't get it do you? Without giving us the proper information your wasting everyones time (yours included).

 

While rajivgonsalves is on to something it still may have nothing to do with your error but we wouldn't know because you haven't told us what it is. WE ARE NOT mind readers.

[premiso]

mysql_query($query, $conn) or die ('Error: Der er opstået en database fejl, og det var derfor ikke muligt at gennemføre aktiveringen<br />MySQL Error:' . mysql_error() ); // this is the error I get

 

Replace that code as it will provide you with the error MySQL is returning.