[Dokins]

pawn Код:

new escape[24], query[64];
                    mysql_real_escape_string(inputtext, escape);
                    format(query, sizeof(query), "SELECT `id` FROM `accounts` WHERE `PlayerName` = '%s' LIMIT 1", escape);
                    mysql_query(query);
                    mysql_store_result();
                    
                    
                    printf("rows %d", mysql_num_rows());

                    if(mysql_num_rows() > 0)
                    {

This function works, except for the last row in the table. It returns:

Quote:

[18:03:21] mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Grant_Reacher' at line 1

in the server log. (That is last name in the TABLE.)