Updating SQL

OK I have this

PHP Code:

---

$update = mysql_query("Update rares set title = '$value' where name = '$name'"); 


---

And I have all the sql tables setup but it doesnt update
Anyone know why?

Cheers

PHP Code:

---

mysql_query("UPDATE rares SET title = $value WHERE name = $name") 


---

Remember before that you have to select your database ect.

PHP Code:

---

mysql_query("SELECT * from rares where name = '$_GET[rares]'");
mysql_query("UPDATE rares SET title = $value WHERE name = $name"); 


---

Still doesnt update it

PHP Code:

---

mysql_query("SELECT * from rares where name = '$_GET[rares]'"); 
mysql_query("UPDATE rares SET title = $value WHERE name = $name"); 


---

Still doesnt update it

mysql_query("SELECT * from rares where name = '$_GET[rares]'");
mysql_query("UPDATE rares SET title = '$value' WHERE name = '$name'");
And check that title and name exists

Edit: And you dont need to select your database, and make sure $value and $name are declared.

:(
Still dont work

PHP Code:

---

$value = htmlspecialchars($_POST[title]); 
$name = htmlspecialchars($_POST[name]);
 
echo ("Rare Updated");
mysql_query("SELECT * from rares where name = '$_GET[rares]'");
mysql_query("UPDATE rares SET title = '$value' WHERE name = '$name'"); 


---

http://img65.imageshack.us/img65/5541/rvwx5.png

CLOSE PLS, FIXED THANKS DUNKO. I HAD MY NAME TEXTBOX CALLED NAEM NOT NAME LOL

They no longer close threads at the request of users.

Oh well. Cheers Drompo n Dunko