[No Fear]

Hi, i have a problem with my script, it's not saving to table

pawn Код:

stock SaveGlobalLogs( )
{

    new
        Query               [ 200 ],
        sBullets = sGlobal  [ Bullets ],
        sMinutes = sGlobal  [ Minutes ]
    ;

    format( Query, sizeof( Query ), "UPDATE `global` (Bullets,Minutes) VALUES(%d,%d)",
    sBullets, sMinutes );

    mysql_query         ( Query );
    mysql_free_result   ( );
    return true;
}

[Vince]

Your syntax is wrong. Refer to dev.mysql.com if unsure about syntax. Correct syntax is:

PHP код:

UPDATE `tablename` SET `field`= 'value', `field2` = 'value' WHERE `field3` = 'value' 


[No Fear]

Tried something like that... nop... can you recreate my script?

[No Fear]

UP, and i'm not using MySQL player data, it's server logs..

[Konstantinos]

The correct syntax at SQL UPDATE Statement is

PHP код:

format( Query, sizeof( Query ), "UPDATE `global` SET `Bullets` = '%d', `Minutes` = '%d'", sBullets, sMinutes ); 


That's optional.

PHP код:

WHERE `field3` = 'value'