Re: [PHP] Get the lowest value out of different fields

From: "Frank Keessen" <[EMAIL PROTECTED]> > I hope you can help me with this: > > I have a tabel in my database like this > > TEST > > fieldnameValue's > > testid 1 > testf1 3 > testf2 4 > testf3 0 > testf4 2 > testf5 0 > > (so this is

RE: [PHP] Get the lowest value out of different fields

[snip] 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 whol

RE: [PHP] Get the lowest value out of different fields

> 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); > } > > -- > Someone will probably come up with someth

Re: [PHP] Get the lowest value out of different fields

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 |

RE: [PHP] Get the lowest value out of different fields

> Hi All, > > I hope you can help me with this: > > I have a tabel in my database like this > > TEST > > fieldnameValue's > > testid 1 > testf1 3 > testf2 4 > testf3 0 > testf4 2 > testf5 0 > > (so this is one record!) > > I want to dis

RE: [PHP] Get the lowest value out of different fields

[snip] I have a tabel in my database like this TEST fieldnameValue's testid 1 testf1 3 testf2 4 testf3 0 testf4 2 testf5 0 (so this is one record!) I want to display the lowest value, except 0.. So the SQL statement will be SEL

RE: [PHP] Get the lowest value out of different fields

Frank Keessen on Wednesday, September 03, 2003 12:14 PM said: > I hope you can help me with this: I hope so too! > TEST > > fieldnameValue's > > testid 1 > testf1 3 > testf2 4 > testf3 0 > testf4 2 > testf5

[PHP] Get the lowest value out of different fields

Hi All, I hope you can help me with this: I have a tabel in my database like this TEST fieldnameValue's testid 1 testf1 3 testf2 4 testf3 0 testf4 2 testf5 0 (so this is one record!) I want to display the lowest value, except