RE: [PHP] Delimiter WITHOUT lots of IF's

[Ralph Guzman]

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