Re: Get the lowest value out of different fields
| From: | Frank Keessen | Date: | Wed, 03 Sep 2003 20:06:56 +0000 |
| Subject: | Re: Get the lowest value out of different fields | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-161588@lists.php.net to get a copy of this message | ||
Hi all,
Thanks for the quick response.. Did a little bit more investigation: (and
made additions to my table)
+--------+--------+--------+--------+--------+
| testid | testf1 | testf2 | testf4 | testf5 | frankid
+--------+--------+--------+--------+--------+
| 1 | 3 | 4 | 0 | 2 | 10
+--------+--------+--------+--------+--------+
| 2 | 8 | 7 | 0 | 6 | 10
+--------+--------+--------+--------+--------+
| 3 | 3 | 4 | 0 | 2 | 8
+--------+--------+--------+--------+--------+
(The layout is from mr. Chris W. Parker!)
O.k. i dropped my lines below: As you can see, i'm selecting FRANKID 10 and
i want to display the lowest value (2 rows are selected)! As you can see a
stole a function from www.php.net/min, Now this is working fine for the
first record!!! BUT how can i make the function loop through the whole
result?
-----------------------------------
if (mysql_num_rows($result3) > 0)
{
$test = mysql_fetch_array($result3);
echo minnum($test);
}
--------------------------------------
Whole code:
<?
include("../conf/config.php");
$connection = mysql_connect($host, $user, $pass) or die ("Unable to
connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
$query3 = "SELECT
testf1 , testf2 , testf3 ,
testf4 , testf5
, FROM test
WHERE frankid = '10'";
$result3 = mysql_query($query3) or die ("Error in query: $query3. " .
mysql_error());
function minnum($numarray){
//dont use min(), it contains a bug!
$min=0;
if ( ! is_array($numarray) ) $numarray = func_get_args();
if(is_array($numarray)==true){
$min=max($numarray);
for($z=0;$z<count($numarray);$z++){
$curval=floatval($numarray[$z]);
if(($curval != 0) && ($curval < $min)){
$min=$curval;
}
}
}
return $min;
}
if (mysql_num_rows($result3) > 0)
{
$test = mysql_fetch_array($result3);
echo minnum($test);
}
?>
Regards,
Frank