Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 7, 2007, 12:55 am
rate this thread
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
... of course the syntax is incorrect
and I am very greafull of any help in this matter.
Re: min and max
$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
JDS Computer Training Corp.