Hi all,
I know I've asked this before and wouldn't be asking again if I had the
email that you people replied back with. Windows took a you know what on me
and I had to format the hard drive.
Anyway here is what I have.
This is items.php:
<form action='buyitem.php' method='post'>
<?
$query = "SELECT id, image, name, quantity, price FROM
{$config["prefix"]}_items where id = 1";
$ret = mysql_query($query);
$return = mysql_fetch_array($ret);
echo "<input type='image' src='images/blueholo.gif'><br>";
echo "<b>$return[name]</b><br>";
echo "Quantity $return[quantity]<br>";
echo "Cost: $return[price] SC<br>";
echo "<input type='hidden' name='ItemID' value='$id'>";
?>
</form>
What I need to accomplish is that when the submit button is clicked the
quantity is subtracted by 1 and then the item is placed in the users item
list in mysql.
This is what I have in buyitem.php but I cant seem to get it to work.
$return["quantity"]=("UPDATE {$config["prefix"]}_items set quantity =
quantity - 1 WHERE id = '$ItemID'");
$result=mysql_query($db["quantity"]);
Would someone be kind enough to help with this?
Thanks for all your help so far.
And thanks in advance.
Jennifer
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
