MY database dont get updated

[x-andeep]

i am a beginerr in php..

and here is my code..which shows error in the querry line..

erro goes like this

 

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\restafinal\process_edit_page.php on line 56

 

and code goes like this..

echo part works well...that query line is the error line..please tell me whats the problem...

 

<?php



//$id=$_GET["id"];
$id= $_GET['id'];
$menu_name= $_POST['menu_name'];

$position= $_POST['position'];
$visible= $_POST['visible'];
$note= $_POST['note'];
$content= $_POST['content'];


//echo part works well..
echo "menu_name"; echo $menu_name;
echo "<br/>";
echo "position"; echo $position;
   echo "<br/>";
echo "visible";  echo  $visible;
    echo "<br/>";
  echo "note";  echo $note;
   echo "<br/>";
echo "id"; echo $id;

echo $content;



	[b]$result = mysql_query(UPDATE page SET note =$note, nevigation = $menu_name WHERE id = $id,$connection)[/b]

		// test to see if the update occurred
		if (mysql_affected_rows() == 1) {
			// Success!



		} else {
			$message = "The page could not be updated.";
			$message .= "<br />" . mysql_error();
		}




?>

[Maq]

Please use

tags.

[Maq]

You're missing a ; at the end of your mysql_query call.