Update not working, any ideas

[tbobker]

Any ideas why this update to the mysql database is not working?

$email=$_POST['email'];
		$temp=$_POST['temp'];
		$pass=$_POST['pass'];

	$sql="update config set Passwd='".$pass."', Template='".$temp."', Email='".$email."'";
	$result=mysql_query($sql, $conn);

	if(!$result){

		echo "there is a problem";
		echo "<script>setTimeout(\"window.location=\'index.php?action=config\'\",1400);   </script>";

	}else{

		 echo "<script>setTimeout(\"window.location=\'index.php?action=config\'\",1400);   </script>";
    }

[Piranha]

The update you do will update every row in the table. Add a where-part to it to select what you want to update.

Also use or dir(...) to get the error if it is not working. Post the error here if you can't solve it yourself.

        $sql="update config set Passwd='".$pass."', Template='".$temp."', Email='".$email."' where id = $id";
        $result=mysql_query($sql, $conn) or die(mysql_error); 

Edit: Don't just take the variables from POST. Use mysql_real_escape_string to make it safe for SQL injection.