Hi i have a problem
i use this tutorial for crete my database end whit file PHP i read/write db
http://www.unifycommunity.com/wiki/index.php?title=Server_Side_Highscores
If i create i file PHP whit comand DELETE work but if i create PHP file whit UPDATE comand not work why?
i have used this code for test for explese if i wont update the score of table scores
<?php
$db = mysql_connect('mysql_host', 'mysql_user', 'mysql_password') or die('Could not connect: ' . mysql_error());
mysql_select_db('my_database') or die('Could not select database');
// Strings must be escaped to prevent SQL injection attack.
$name = mysql_real_escape_string($_GET['name'], $db);
$score = mysql_real_escape_string($_GET['score'], $db);
$hash = $_GET['hash'];
$secretKey="mySecretKey"; # Change this value to match the value stored in the client javascript below
$real_hash = md5($name . $score . $secretKey);
if($real_hash == $hash) {
// Send variables for the MySQL database class.
$query = "UPDATE scores SET score = $score WHERE Name = $name";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
}
?>
but not update why?