Actually, I missed a few things on that function. It should look like this:
function cart_cdqty() { $query = "SELECT SUM(sess_itemsize) AS total_size FROM sessions WHERE sess_id = ".$_COOKIE['SID'].""; $result = mysql_query($query); if(!$row = mysql_fetch_array($result)) { return false; } else { $n = $row['total_size']; $x = ceil( $n / 690.0 ); $cart_cdqty = array( 'quantity' => $x, 'total_size' => $n ); return $cart_cdqty; } } -----Original Message----- From: Ralph Guzman [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 11:41 PM To: 'Cesar Aracena'; [EMAIL PROTECTED] Subject: RE: [PHP] Delimiter WITHOUT lots of IF's Sensitivity: Confidential I agree with Curt, use mySQL to get the sum of 'sess_itemsize' then divide the result by size per disk to get quantity. So your function should look something like this: function cart_cdqty() { $query = "SELECT SUM(sess_itemsize) AS total_size FROM sessions WHERE sess_id = ".$_COOKIE['SID'].""; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $n = $row['total_size']; $x = ceil( $n / 690.0 ); $cart_cdqty = array( 'quantity' => '$x', 'total_size' => '$n', ); return $cart_cdqty; } else { return false; } } Then all you do is call the function like this: if(!$cdqty = cart_cdqty()) { print 'no items found in your shopping cart'; } else { print 'Total Size:' . $cdqty['quantity'] . '<BR>'; print 'Total CDs:' . $cdqty['total_size'] . 'MBs <BR>'; } I have not tested this but it should work. Ralph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php