query("SELECT * FROM items"); $num = $perform->num_rows($items); echo "Item ID\t\tItem Name\t\tPrice\t\tNew Price
"; while($item = $perform->fetch_array($items)) { echo $item['itemid']; echo "\t\t"; echo $item['itemname']; echo "\t\t"; echo $item['itemprice']; echo "\t\t"; $newprice = $item['itemprice'] - $lowerval; echo $newprice; echo "
\r\n"; $perform->query("UPDATE items SET itemprice = '".$newprice."' WHERE itemid = '".$item['itemid']."' LIMIT 1"); } ?>