MYSQL Highest Field Value - Printable Version

MYSQL Highest Field Value - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL Highest Field Value (/showthread.php?tid=391288)

MYSQL Highest Field Value - Ballu Miaa - 10.11.2012

Hello Everyone,

I want to get the highest value of a field in a MYSQL table.

I have this custom function to return the highest value of a field from the SQLite table. It works perfectly, Here is the function in SQLite:

pawn Код:

stock sqlite_highest_field(DB:db, fieldname[], tablename[])
{
    new querys[128], DBResult:qresult, id = -1, queryresult[128];
    format(querys, sizeof(querys), "SELECT max( `%s` ) FROM `%s`", fieldname, tablename);
    qresult = db_query(db, querys);
    db_get_field(qresult,0,queryresult,128);
    id = strval(queryresult);
    db_free_result(qresult);
    return id;
}

My friend 'Ronaldo_raul™' helped me to code a new function for MYSQL. But it always return -1.

Is there anyone who can fix this function? so that it will return the Highest value of a field in a table??

pawn Код:

stock name ( fieldname [] , tablename [] )
{
    new qry [ 128 ] , val = -1 ;
    format( qry , 128 , "SELECT max( `%s` ) FROM `%s`" , fieldname , tablename ) ;
    mysql_query ( qry ) ;
    mysql_store_result ( ) ;
    new rows = mysql_num_rows ( ) ;
    mysql_free_result ( ) ;
    if(!rows) return 0 ;
    else return val ;
}

Thank You
Ballu Miaa

Re: MYSQL Highest Field Value - ReneG - 10.11.2012

You forgot to fetch the field into the integer.

pawn Код:

stock name ( fieldname [] , tablename [] )
{
    new qry [ 128 ] , val = -1 ;
    format( qry , 128 , "SELECT max( `%s` ) FROM `%s`" , fieldname , tablename ) ;
    mysql_query ( qry ) ;
    mysql_store_result ( ) ;
    new rows = mysql_num_rows ( ) ;
    mysql_free_result ( ) ;
    if(!rows) return -1 ;
    val = mysql_fetch_int ( ) ; 
    return val;
}

Re: MYSQL Highest Field Value - Ballu Miaa - 10.11.2012

Quote:

Originally Posted by VincentDunn

You forgot to fetch the field into the integer.

pawn Код:

stock name ( fieldname [] , tablename [] )
{
    new qry [ 128 ] , val = -1 ;
    format( qry , 128 , "SELECT max( `%s` ) FROM `%s`" , fieldname , tablename ) ;
    mysql_query ( qry ) ;
    mysql_store_result ( ) ;
    new rows = mysql_num_rows ( ) ;
    mysql_free_result ( ) ;
    if(!rows) return -1 ;
    val = mysql_fetch_int ( ) ; 
    return val;
}

Okay thanks for that Vinci but there was one more fault, it worked like:

pawn Код:

stock name ( fieldname [] , tablename [] )
{
    new qry [ 128 ] , val = -1 ;
    format( qry , 128 , "SELECT max( `%s` ) FROM `%s`" , fieldname , tablename ) ;
    mysql_query ( qry ) ;
    mysql_store_result ( ) ;
    new rows = mysql_num_rows ( ) ;
    if(!rows) return -1 ;
    val = mysql_fetch_int ( ) ;
    mysql_free_result ( ) ;
    return val;
}

Re: MYSQL Highest Field Value - Ronaldo_raul™ - 10.11.2012

Quote:

Originally Posted by VincentDunn

You forgot to fetch the field into the integer.

pawn Код:

stock name ( fieldname [] , tablename [] )
{
    new qry [ 128 ] , val = -1 ;
    format( qry , 128 , "SELECT max( `%s` ) FROM `%s`" , fieldname , tablename ) ;
    mysql_query ( qry ) ;
    mysql_store_result ( ) ;
    new rows = mysql_num_rows ( ) ;
    mysql_free_result ( ) ;
    if(!rows) return -1 ;
    val = mysql_fetch_int ( ) ; 
    return val;
}

Damn, I forgot the main part

@Ballu - You must have told me it returned -1

e.e

Re: MYSQL Highest Field Value - Ballu Miaa - 10.11.2012

Quote:

Originally Posted by Ronaldo_raul™

Damn, I forgot the main part

@Ballu - You must have told me it returned -1

e.e

Uhh My bad bro! you did half of the work for me. I appreciate it. Just dont want to burden you with this.

Anyways thanks for helping me in LoadingBusiness also.