Unknown mysql error.

[lszanto]

Every time I edit news on my news system for some reason it has no error but it doesn't update the news, this is the code that updates it.

      if(isset($_POST['subed'])) {
	//Get vars.
	$id = $_POST['id'];
	$day = $_POST['day'];
	$title = $_POST['title'];
	$post = $_POST['post'];
	$month = $_POST['month'];

	//Make insert query.
	$sql = "UPDATE news SET month='$month' AND day=$day AND title='$title' AND post='$post' WHERE id=$id";

	//Insert data.
	mysql_query($sql) or die(mysql_error());

	//Tell user data has been entered.
	echo "The news has been edited, please click <a href=\"news.php\" >here</a> to view the news.";

  }

[mmarif4u]

Every time I edit news on my news system for some reason it has no error but it doesn't update the news, this is the code that updates it.

      if(isset($_POST['subed'])) {
	//Get vars.
	$id = $_POST['id'];
	$day = $_POST['day'];
	$title = $_POST['title'];
	$post = $_POST['post'];
	$month = $_POST['month'];

	//Make insert query.
	$sql = "UPDATE news SET month='$month' AND day=$day AND title='$title' AND post='$post' WHERE id=$id";

	//Insert data.
	mysql_query($sql) or die(mysql_error());

	//Tell user data has been entered.
	echo "The news has been edited, please click <a href=\"news.php\" >here</a> to view the news.";

  }

Try this:

$sql = "UPDATE news SET month='$month' AND day='$day' AND title='$title' AND post='$post' WHERE id='$id'";