How to UPDATE in SQL DB?

[simonyuriko]

I'm having problems updating posts in the SQL-DB..

Here's my code for update:

<?php
mysql_connect("localhost","root") or die(mysql_error());
mysql_select_db("log") or die(mysql_error());
$id = $REQUEST["id"];
$title = $REQUEST["title"];
$head = $REQUEST["head"];
$log = $REQUEST["log"];
$sql = "UPDATE user SET
title='$title', head='$head', log='$log'
WHERE id=$id";
$result = mysql_query($sql);
?>

Here's the update formpage

<?php
$conn = mysql_connect("localhost", "root");
mysql_select_db("log");
$result = mysql_query('SELECT * FROM new WHERE id =
'.mysql_real_escape_string($_GET['id']));
while ($row = mysql_fetch_array($result)) {
printf ("
<form action=\"update.php\" method=\"post\">
<b>ID:</b> <input type=\"hidden\" name=\"id\" value=".$row["id"].">".$row["id"]."<br>
<b>Title:</b> <textarea name=\"title\" cols=\"30\" rows=\"2\">".$row["title"]."</textarea><br>
<b>Head:</b> <textarea name=\"head\" cols=\"30\" rows=\"2\">".$row["head"]."</textarea><br>
<b>Log:</b> <textarea name=\"log\" cols=\"30\" rows=\"10\">".$row["log"]."</textarea><br>
<input type=\"submit\" value=\"Save\">
</form>");
}
mysql_close($conn);
?>

Can someone help me please 😕

Thanks 🙂

[superwormy]

Whats the problem?

Why don't you use mysql_query ($query) or die (mysql_error()); so you can see if you have a syntax error?

And why do people always do this:
$id = $REQUEST["id"];
$title = $REQUEST["title"];
$head = $REQUEST["head"];
$log = $REQUEST["log"];

Why not just:

$result = mysql_query ("UPDATE user SET title = '" . $REQUEST['title'] . "', head = '" . $REQUEST['head'] . "', lo... etc. etc.