snippetsmania.com
Post and share your code snippets

function updateLossPoints($PlayerID) {
$TLP = 0;
$result = mysql_query("SELECT `ShipID` FROM `Kill` WHERE `PlayerID` = '".$PlayerID."'");

while($data = mysql_fetch_array($result)) {
$ShipID = $data['ShipID'];

$get_points = mysql_query("SELECT `Points` FROM `Ship` WHERE ShipID = ".$ShipID."");
$TLP = $TLP + $get_points;
echo $get_points;
}

#mysql_query("UPDATE Player SET LossPoints = ".$TLP." WHERE PlayerID = ".$PlayerID."");
}

source