Replacing Data In SQL

[oliverj777]

Hello,

 

I have an SQL table called 'highscores' and I want to find a field called 'player' which matches - $PlayerToChangeScore, and then to replace 'score' that is associated with the player, an replace it with - $ChangeScore.

 

$ChangeScore = $_POST["PHPnewScoreChange"];
$PlayerToChangeScore = $_POST["PHPcurrentPlayerChange"];

 

 

Hope that makes sense, thanks

[TOA]

If I understand you correctly, I think this is what you need

 

UPDATE highscores SET score='$ChangeScore' WHERE player='$PlayerToChangeScore'

 

Luck

[xyph]

<?php

$sql = new mysqli( 'localhost', 'root', '', 'db' );

if( isset($_POST['PHPnewScoreChange']) && isset($_POST['PHPcurrentPlayerChange']) ) {
   $query = 'UPDATE `table` SET
      `highscores` = \'' . $sql->escape_string( $_POST['PHPnewScoreChange'] ) . '\'
      WHERE `player` = \'' . $sql->escape_string( $_POST['PHPcurrentPlayerChange'] ) . '\'';
   if( $sql->query( $query ) )
      echo 'Score updated successfully.';
   else
      echo 'Could not update score.';
}

?>