|
|
Posted by Jerry Stuckle on 02/07/07 01:17
GarryJones wrote:
> 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,
> ml_lopp.loppnum';
>
> $ml_upg=mysql_query($ml_collect);
>
> mysql_close();
>
> The field is contained within the table ml_lopp and it is called
> loppnum
>
> 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.
>
> $lownum=mysql_result($ml_upg,MIN('loppnum'));
> $hghnum=mysql_result($ml_upg,MAX('loppnum'));;
>
> ... of course the syntax is incorrect
>
> and I am very greafull of any help in this matter.
>
> Garry Jones
> Sweden
>
Garry,
$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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|