[fatlirmorina]

Well, I am trying to make an ban system but whatever SQL always occurs errors cos I'm a noobie.

Gimme a hand.
Errors:

Код:

[17:59:41] [ERROR] CMySQLQuery::Execute - (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 'SELCET * FROM `bans` WHERE `ip` = '127.0.0.1'' at line 1
[17:59:41] [WARNING] cache_get_row_count - no active cache
[17:59:41] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')

Script:

Код:

new sql123[500], Cache:result;
	mysql_format(sqldb, sql123, sizeof sql123, "SELCET * FROM `bans` WHERE `ip` = '%s'", plrIP);
 	result = mysql_query(sqldb, sql123);
	if(cache_num_rows())
	{
	    SendClientMessage(playerid, -1, "works");
	}
	cache_delete(result);