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();
}
?>