php更新mysql数据库字段,使用HTML表单和PHP更新MySQL数据库字段数据

So I am trying to update a database field using a html form and some PHP code, but I cannot get it to work, it throws no errors but does not update the field?, Im not sure if its because im also echoing that field on the webpage? All it seems to do is print the fail message.

HTML:

Description:

PHP:

mysql_connect("localhost", "root", "*****") or die("Connection Failed");

mysql_select_db("Days")or die("Connection Failed");

$description = $_POST['description'];

$query = "UPDATE test SET description = '$description' ";

if(mysql_query($query)){ echo "updated";} else{ echo "fail";} ?>

My echo (working):

include("include/session.php");

//connect to the server

$connect = mysql_connect("localhost","root","*****");

//connect to the database

mysql_select_db("days");

//query the database

$query = mysql_query("SELECT * FROM hobby WHERE id = '1' ");

//ferch the results / convert results into an array

WHILE($rows = mysql_fetch_array($query)):

$description = $rows['description'];

echo "

$description";

endwhile;

?>

解决方案UPDATE table_name

SET column1=value, column2=value2,...

WHERE some_column=some_value

Update query sample but i don't get your sql ..you missing your where clause