Stuff

<?
	$lowerval = 2.00;
	include("./global.php");
	$items = $perform->query("SELECT * FROM items");
	$num = $perform->num_rows($items);
	echo "<b>Item ID\t\tItem Name\t\tPrice\t\tNew Price</b><br>";
	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 "<br>\r\n";
		$perform->query("UPDATE items SET itemprice = '".$newprice."' WHERE itemid = '".$item['itemid']."' LIMIT 1");
		
	}


?>