delete~

lucky109 · **Author**

thanks~^^

Greenberet · 07-23-2007 , 13:23 Re: MYSQL get MAX result problem!

Code:

test = dbi_result( result, "MAX(`number`)" );

or try

Code:

test = dbi_field(result,1);

or

Code:

new Result:result;
result = dbi_query(dbc,"SELECT MAX(`number`) as maxnumber FROM `table`");
new test = dbi_result(result, "maxnumber") ;
client_print(id,print_chat,"[AMXX] The Max Number Is %d",test);

lucky109 · 07-23-2007 , 13:40 Re: MYSQL get MAX result problem!

Quote:

Originally Posted by Greenberet

Code:

test = dbi_result( result, "MAX(`number`)" );

or try

Code:

test = dbi_field(result,1);

or

Code:

new Result:result;
result = dbi_query(dbc,"SELECT MAX(`number`) as maxnumber FROM `table`");
new test = dbi_result(result, "maxnumber") ;
client_print(id,print_chat,"[AMXX] The Max Number Is %d",test);

thank you~ this's work....+Karma^^

Code:

test = dbi_field(result,1);