[NeXoR]

I inserted a row to my user database, in order to test my IP banning system
That's the pawn code

PHP Code:

    new query[248];
    mysql_format(mysql, query, sizeof(query), "SELECT `BannedBy`, `BanReason`, `BannedDate`, `Username` WHERE `IP`='%e' AND `Banned`='1'", RPIP(playerid));
    mysql_tquery(mysql, query, "CheckBan", "i", playerid); 


PHP Code:

forward CheckBan(playerid);
public CheckBan(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields, mysql);
    if(rows)
    {
        new banreason[128], bannedby[24], bandate[10], username[24], string[128];
        cache_get_field_content(0, "BannedBy", bannedby, mysql, sizeof(bannedby));
        cache_get_field_content(0, "BanReason", banreason, mysql, sizeof(banreason));
        cache_get_field_content(0, "BannedDate", bandate, mysql, sizeof(bandate));
        cache_get_field_content(0, "Username", username, mysql, sizeof(username));
        SendClientMessage(playerid, COLOR_GREEN, "-------[Banned]-------");
        format(string, sizeof(string), "Username: %s || Banning Date: %s", username, bandate);
        SendClientMessage(playerid, COLOR_RED, string);
        format(string, sizeof(string), "IP Address: %s || Banned By: %s", RPIP(playerid), bannedby);
        SendClientMessage(playerid, COLOR_RED, string);
        format(string, sizeof(string), "Reason: %s", banreason);
        SendClientMessage(playerid, COLOR_RED, string);
        SendClientMessage(playerid, COLOR_YELLOW, "If you think that you have been wrongfully banned, visit our forums and apply for an unban.");
        SendClientMessage(playerid, COLOR_GREEN, "-------[Banned]-------");
        SetTimerEx("DelayedKick", 1000, 0, "i", playerid);
    }
} 


That's the error:

Code:

[01:35:09] [ERROR] CMySQLQuery::Execute[CheckBan] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `IP`='127.0.0.1' AND `Banned`='1'' at line 1