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

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

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