Help Changing Product System

[Elangler]

Currently, in my shopping cart, it checks for a product id. If it already exists, it adds to the value ct_qty.

 

if (dbNumRows($result) == 0) {
	// put the product in cart table
	$sql = "INSERT INTO tbl_cart (pd_id, ct_qty, ct_session_id, item_color, item_size, ct_date)
			VALUES ($productId, 1, '$sid', '$color', '$size', NOW())";
	$result = dbQuery($sql);
	}



else{
	$sql = "UPDATE tbl_cart 
	        SET ct_qty = ct_qty + 1
			WHERE ct_session_id = '$sid' AND pd_id = $productId";		

	$result = dbQuery($sql);	

But I want to be able to compare all the products where the product ids are the same, as well as session id. If one product exists and matches the same color AND size I want that quantity to update. If not, just add another item.  My problem is I'm not sure how to access every single row that matches the product id and session id. Any help is appreciated.

[Elangler]

Bump.. Basically just asking how I could grab all the table date and search through it in a loop.