[RESOLVED] Updating the Databse?

[IceRegent]

Ok, now that I have the form working correctly, I cannt seem to get my update script working right. Here is the script to update the database, that is not working:

<?php
include 'config.php';
echo 'Song Change Update script';
$field1=$_POST['songname'];
$field2=$_POST['songdesc'];
$field3=$_POST['songlyrics'];

//Now we need to update the song table with the new info
$sql = "UPDATE songs SET (sid, name, description, lyrics) VALUES (NULL, $field1, $field2, $field3) WHERE name == $field1";
mysql_query($sql);
?>

The result is that nothing happens with the database.

Am I using a wrong syntax, or?

Thank you;
Ice

[leagal4ever]

$sql = "UPDATE songs SET name=$field1, description=$field2, lyrics=$field3 WHERE name = $field1"; 

[NogDog]

The values used in the query have to be quoted if they are not simple numeric values, as well as the value in the where clause. Also, the MySQL equality operator is "=", not "==".

$sql = "UPDATE songs SET description = '$field2', lyrics = '$field3' WHERE name = '$field1'";

Also, those user input values should be escaped (see [man]mysql_real_escape_string/man) before using them in a query.

PS: It's redundant to set name='$field1' when you know it already is set to that value, since your where clause requires it to be.