min and max

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I wish to assign a variable name to the MIN and MAX values of a field
in a table. The type is int(7).

I am extracting the field with many others with the following code
from a php call.

$ml_collect='SELECT * FROM ml_lopp LEFT JOIN scfmforening ON
(scfmforening.scfmnum=ml_lopp.scfmnum) LEFT JOIN ml_newtidplats ON
(ml_newtidplats.loppnum=ml_lopp.loppnum) ORDER BY date1,



The field is contained within the table ml_lopp and it is called

I have been trying combinations of this to extract the min and max of
the field from the $ml_upg variable which includes all of the data to
be processed.


... of course the syntax is incorrect

and I am very greafull of any help in this matter.

Garry Jones

Re: min and max

GarryJones wrote:
Quoted text here. Click to load it


$ml_upg is a result set - it does not 'contain the results' - rather it  
is an anchor used to retrieve the result sets.

You can retrieve the results one at a time, checking each retrieved row  
to see if you have a larger or smaller value than previously retrieved  
(or read everything into an array and find the min and max values that  
way).  Alternatively, you can issue another SQL statement to get the min  
and max values of the field.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline