Error på kode (hentning af data fra databasen)
Hej eksperter.Har den her kode:
<html><head><title>Buy Weapon</title></head><body>
<?php
session_start();
if(!$_SESSION[user_id] > 0) {
header("location:index.php");
exit;
}
require_once('connect.php');
$query = mysql_query("SELECT * FROM weapons WHERE id=$_POST[id]");
$weapon_data = mysql_fetch_assoc($query) or die(mysql_error());
$user_query = mysql_query("SELECT * FROM players WHERE id='$_SESSION[user_id]'");
$user_data = mysql_fetch_assoc($user_query) or die(mysql_error());
if($weapon_data["buyvalue"] <= $user_data["money"]
{
mysql_query("UPDATE players SET weaponname = '$weapon_data[wname]' WHERE id='$_SESSION[user_id]'") or die(mysql_error());
mysql_query("UPDATE players SET weaponid = '$weapon_data[id]' WHERE id='$_SESSION[user_id]'") or die(mysql_error());
echo nl2br($weapon_data["wname"] . " has been added to your inventory\n");
mysql_query("UPDATE players SET money = '$user_data[money]' - '$weapon_data[buyvalue]' WHERE id='$_SESSION[user_id]'") or die(mysql_error());
echo $weapon_data["buyvalue"] . " gold have been removed from your account.";
} else {
echo "Sorry you only have " . $user_data["money"] . " and " . $weapon_data["wname"] . " cost " . $weapondata["buyvalue"];
}
?>
<br><br><br>
<a href="play.php">Return</a>
</body>
</html>
og får den her fejl, kan ikke rigtig se hvorfor? :S
Parse error: syntax error, unexpected ';' in /home/virtual/xsix.dk/public_html/online/buyweapon2.php on line 16
På forhånd tak,
Mvh.
XsiX
