Updating SQL

[Robbie]

OK I have this

$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

[Drompo]

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

Remember before that you have to select your database ect.

[Robbie]

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

Still doesnt update it

[Robbie]

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

Still doesnt update it

[Blob]

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.

[Robbie]

Still dont work

$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'"); 

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

[Dentafrice1]

They no longer close threads at the request of users.

[Robbie]

Oh well. Cheers Drompo n Dunko