Update a Record Problem

[Anon]

I'm trying to simply update a field in my mysql database but I've got no idea what's going wrong...

<?php
require("./../../adodbfolder/adodb.inc.php");
require("./../../Connections/myconnection.php");
?><?php
$query = "UPDATE realestate_estates SET estate_status = ($suspendactivate) WHERE estate_id = ($e_id)";
$result = mysql_query($query);
?>

Can anyone spot the problem with the above?
I'm passing information to the above SQL via a link:
http://www.mydomain.com/updatepage.php?suspendactivate=S&e_id=2

What I want the above SQL to do is, change the value of the column "estate_status" to the value sent in "suspendactivate" in this case "S", WHERE the column "estate_id" matches the value sent in "e_id", in this case "2".

Can someone help me out please!

Thanks,

Peter

[Anon]

It should look like this:

$query = "UPDATE realestate_estates SET estate_status = '$suspendactivate' WHERE estate_id = $e_id";

[Anon]

Thanks! I was just about to reply that I tried that and it worked, but you beat me. ;-)

Thank you very much for the help anyway!

Peter