$pg=$_GET['pg'];
extract($_POST);
include ('dbinfo.inc.php');
$cartId = $_POST['hidCartId'];
$productId = $_POST['hidProductId'];
$itemQty = $_POST['txtQty'];
$numItem = count($itemQty);
$numDeleted = 0;
$cid = mysql_connect($host,$username,$password);
mysql_select_db($database);
if (mysql_error()) { print "Database ERROR: " . mysql_error(); }
$sql = "UPDATE `cart` SET `quantity` = '$newQty' WHERE `cartID` = '{$cartId[$i]}' " ;
$result = mysql_query($sql, $cid);
if (mysql_error()) { print "Database Error: $sql " . mysql_error(); }
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM cart WHERE `cart_session`='$cart_session'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$j=0;$colorcount=0;
while ($j < $num) {
$vcid=mysql_result($result,$j,"cartID");
$vqty=mysql_result($result,$j,"quantity");
$vpid=mysql_result($result,$j,"productID");
$vorder=mysql_result($result,$j,"ordered");
$j++;
}
header("location:index.php?pg=16");
$_SESSION["valid_user"] = $_POST["myusername"];
http://www.pantz.org/software/mysql/mysqlcommands.html


