Code: Select all

 $update_gold = "UPDATE stats SET gold='$gold1' AND food='$food1' WHERE $id = '$_SESSION[userid]";

Code: Select all

$update_gold = "UPDATE stats SET gold='$gold1',food='$food1' WHERE $id = '$_SESSION[userid]'";

Code: Select all

$sql = "UPDATE `ranking` SET `attack`='".$i."' WHERE `id`='".$attack['id']."'";
$sql = "UPDATE `ranking` SET `defense`='".$i."' WHERE `id`='".$defense['id']."'";

Code: Select all

mysqli_query($db_conx, $sql);