[SOLVED] Unknown column 'activated' in 'field list'

[Wildhalf]

Hi All,

 

When i was testing my file on my local machine using Xampp everything worked fine. But now that i have uploaded it to my server i get the following error when i get my use to click on there actiation link....

 

Unknown column 'activated' in 'field list'

 

Activated is the name of my PHP file. its not a field

 

Link i use to activate account

http://www.mysite.com/[email protected]&name=TSteve&site=confirm

 

<?


// Get database connection
include 'db.php';

// Define post fields into simple variables
$email = $_REQUEST['email'];
$name = $_REQUEST['name'];
$site = $_REQUEST['site'];

$sql2 = mysql_query("UPDATE tblmembers SET activated=1 WHERE email='$email'")
or die (mysql_error());

print "eMail : $email";
print "<br>";
print "Account Activated";

include "activated_html.php";
?>

[Wildhalf]

Just figured it out myself........

 

Thought i had updated everything since last test but never changed the Database files....