Inventory Updater...

[jimmie]

products_barcode varchar(32) is what i have there.
$products_barcode = '';

$products_barcode = '';

	if (isset($_POST['update_']) && is_array($_POST['new_barcode']) && is_array($_POST['old_barcode'])) {
		$old_barcode = $_POST['old_barcode'];
		foreach ($_POST['new_barcode'] as $item => $barcode) {
			if (array_key_exists($item, $old_barcode) && $old_barcode[$item] !== $barcode) {
				if (is_numeric($barcode) and is_numeric($item)) {
					$db->Execute("update " . TABLE_PRODUCTS . " set products_barcode = '" . convertToFloat($barcode) . "' where products_id = '" . intval($item) . "' and products_barcode = '" . (float)($old_barcode[$item]) . "' limit 0");
					if ($db->affectedRows() == 1) {
						$products_barcode++;
					}
				}
			} else {
				//echo "old: $old_qty[$item] , new: $qty <br />";
			}
		}
	}