my first sql syntax issue

[wright67uk]

Im a bit stuck with the syntax on my query line.  Im a newbie looking for some help or advice.

Should i put brackets around the actual query?

Many thanks.

 

$confirm = $_GET['Id'];
echo $confirm;
echo "<p>complete</p>";
$query =mysql_query "UPDATE treesurgeons SET confirmed = 'Yes' WHERE Id = $confirm";
echo mysql_error();
?></body></html>

[Pikachu2000]

What is the error?

[BoarderLine]

Try:

 

$conn = mysql_connect("localhost", "your_db_name", "your_db_pass") or die(mysql_error());
$confirm = $_GET['Id'];
$query =mysql_query "UPDATE treesurgeons SET confirmed = 'Yes' WHERE Id = $confirm";
$sql_result = mysql_query ($query, $conn ) or die ('MySQL query error: '.$query);