that did not fix my script. My script is to buy an item in a store and it is the following
<?php
if ($_COOKIE['user'] == "")
{
echo "<body bgcolor='000000' text='ffffff'>";
die("Please Login");
}
?>
<?php
include"jocey.inc.php";
$username = $_COOKIE['user'];
$item = $_GET['item'];
$connection = mysql_connect($host, $user,$password)
or die ("Couldn't connect to server.");
mysql_select_db($database, $connection)
or die ("Couldn't select database.");
$result = mysql_query("SELECT * FROM el_items WHERE name='$item'");
$array = mysql_fetch_array($result,MYSQL_ASSOC);
$result2 = mysql_query("SELECT * FROM members WHERE username='$username'");
$row = mysql_fetch_array($result2,MYSQL_ASSOC);
$result3 = mysql_query("SELECT * FROM el_storesstock WHERE iname='$item'");
$iinfo = mysql_fetch_array($result3,MYSQL_ASSOC);
if ($action == "buy")
{
echo "<body bgcolor='000000' text='ffffff'>";
if ($row[money] < $array[price])
{
echo "You can't afford to buy it";
exit("");
}
elseif ($iinfo[stock] == 0)
{
echo "That item is out of stock";
exit("");
}
else
{
$stock = iinfo['stock'] - 1;
$money = $row['money'] - $array['price'];
$sql = "UPDATE el_storesstock SET stock='$stock' WHERE iname='$item'";
mysql_query($sql) or die(mysql_error());
$sql = "UPDATE members SET money='$money' WHERE username='$username'";
mysql_query($sql) or die(mysql_error());
$query = "INSERT INTO el_inventory (username,name) VALUES ('$username','$item')";
mysql_query($query) or die (mysql_error());
echo "<a href='pack.php'>Go To Your Pack</a>";
exit("");
}
exit("");
}
?>
<title>Elarune - Store Actions</title>
<?PHP
include"colours.inc.php";
?>
<center>
<table border=1
width = 250>
<tr border=0><td border=0>
<center>
<?PHP
echo "<img src='$array[pic]'></img>";
echo "<br><b>";
echo $array[name];
echo "</b>";
?>
</td></tr>
<tr><td>
<center><?php echo "Description: $array[description]
<br>Type: $array[type]
<br>Price: $array[price] Gold"; ?>
</td></tr>
<tr border=0><td>
<center>
<?php echo "<form action='storeaction.php?name=$item&action=buy' method='post'><INPUT TYPE='submit' value='Buy $item'>
</form>" ?>
</td></tr>
</table>
Now I worked tell i added this part
$result3 = mysql_query("SELECT * FROM el_storesstock WHERE iname='$item'");
$iinfo = mysql_fetch_array($result3,MYSQL_ASSOC);
if ($action == "buy")
{
echo "<body bgcolor='000000' text='ffffff'>";
if ($row[money] < $array[price])
{
echo "You can't afford to buy it";
exit("");
}
elseif ($iinfo[stock] == 0)
{
echo "That item is out of stock";
exit("");
}
else
{
$stock = iinfo['stock'] - 1;
$money = $row['money'] - $array['price'];
$sql = "UPDATE el_storesstock SET stock='$stock' WHERE iname='$item'";
mysql_query($sql) or die(mysql_error());
$sql = "UPDATE members SET money='$money' WHERE username='$username'";
mysql_query($sql) or die(mysql_error());
$query = "INSERT INTO el_inventory (username,name) VALUES ('$username','$item')";
mysql_query($query) or die (mysql_error());
echo "<a href='pack.php'>Go To Your Pack</a>";
exit("");
}
exit("");
}
it gives me an error on line 47 which is the line
$stock = iinfo['stock'] - 1;
So i dont know what is wrong with it. And the parse error is just a normal parse error
