Forums

hi, i have a problem with mysql.
i have a table Example: a,b,c, c= max(a,b). please help me max(a,b) ?
I don't know how to use max(); must i to create a procedure ?

Hi Tonythuan,

Please post the whole sql query - can't help without the context.

Bob

my table Example have 4 field : a(int), b(int), c(int),d(int).
the problem is : c = max(a,b), d=c/a;
I create a chronoform to insert data of field a and field b to my table. And the values of field c and field d will be caculated antomatically ?

Hi,

try to do it the same way we did it at the other thread ? you don;t have to use the MAX of MYSQL, use the PHP's one ?

Regards
Max