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