|
|
Posted by GarryJones on 02/07/07 00:55
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
Navigation:
[Reply to this message]
|