* Thus wrote Cesar Aracena ([EMAIL PROTECTED]): > Ok. Here you have the entire function to see how many CD's the order > will contain: > > function cart_cdqty() > { > $query = "SELECT * FROM sessions WHERE sess_sid = > ".$_COOKIE['SID'].""; > $result = mysql_query($query); > $num_rows = mysql_num_rows($result); > > $x = 0; > $n = 0; > > for ($y = 0; $y < $num_rows; $y++) > { > $row = mysql_fetch_array($result); > $n = $n + $row[sess_itemsize]; > }
For one, sql can handle this for you. much faster too, I might add. just do something like: select sum(sess_itemsize) from sessions where sess_id = ... ... $result = mysql_query($query); list($n) = mysql_fetch_row($result); > > if ($n > 0 AND $n <= 690.0) { > $x = 1; > } elseif ($n > 690.1 AND $n <= 1380.0) { > $x = 2; > } elseif ($n > 1380.1 AND $n <= 2070.0) { > $x = 3; > } elseif ($n > 2070.1 AND $n <= 2760.0) { > $x = 4; > } elseif ($n > 2760.1 AND $n <= 3450.0) { > $x = 5; > } A simple division of the size per disk will give you the qty: $x = ceil( $n / 690.0 ); Now it wont be so bad if someone is ording 30 disks worth... i'd hate to see that if statment not to mention write it :) You might want to check for $x < 0 cause I don't think the customer will be happy if he has to pay you to send you his disks. Curt -- "I used to think I was indecisive, but now I'm not so sure." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php