Max Function resolved

How can I get the max value from a record set im pulling back, Im creating a table by looping thro the record set.

PHP Code:

---

<?php


$result = mysql_query("SELECT order_code, description, price, postage, quantity FROM tbl_cart WHERE transid='" . $_SESSION['cartnumber'] . "'") or die(mysql_error()); 

$num_rows = mysql_num_rows($result);
    
        if (!($num_rows))        
        {
            //format all this pretty pretty
            die('Your shopping cart is empty.'. mysql_error());
        
        }

?>

---

and im populating a table with this

PHP Code:

---

  <table width="100%" border="1">
    <tr><th>Item Code</th> <th>Description</th> <th>Quantity</th> <th>Price</th> <th>Total</th><th>Remove</th></tr>
<?php 
        while($row = mysql_fetch_array( $result )) {
        $amount = $row['quantity'];
        $price = ltrim($row['price'],£);
        $tamount = ($amount * $price);
        $gt = $gt + $tamount;
echo    '<td width="10%">'.$row['order_code']. '</td>';
echo    '<td width="50%">'.$row['description']. '</td>';
echo    '<td width="10%">'. $row['quantity']. '</td>';
echo    '<td width="10%">'.$row['price']. '</td>';
echo    '<td width="10%">' . '£' . $tamount . '</td>';
echo    '<td width="10%"><a href="deleteentryfromcart.php?oc='.$row['order_code'].'&transid=' . $_SESSION['cartnumber'] .'" target="_self">Remove</a></td>';
echo    '</tr>';

}
?>
  </table>

---

I need to find the highest value in the postage field, I have found the max() function but im not sure how to incorate it into the loop.

thanks Chris

The max() function is a grouping function. What do you mean? Do you want the highest postage amount to be first or only the records with the highest postage amount?

i want to only use the highest postage cost so for instance i have

1.50
1.20
1.60
1.99

then i will get 1.99 as my value.

as it happens i have got around this by loading each value into a array and then using rsort($rarray) on it that way I can just pull the 0 element and know that that is the highest.

if there is a better way please show me...i want to learn


cheers
chrisio

Its actually quite a small query:

Code:

---

SELECT Max(postage) FROM tablename;

---

Will give a result set containing one row and one column, with the maximum value in.

Quote:

---

Originally Posted by visualAd

Its actually quite a small query:

Code:

---

SELECT Max(postage) FROM tablename;

---

Will give a result set containing one row and one column, with the maximum value in.

---

Thanks I knew there would be an easier way. :rolleyes: