[SandKing94]

I am trying to load user's name and pass but i cant and get errors in mysql_log
I am using latest MySQL plugin (BlueG's)
Code:

Код:

new query[200];
    format(query,sizeof(query),"user WHERE user ='%s'",name(playerid));
    cache_get_row(0, 0, pInfo[playerid][user]);
	format(query,sizeof(query),"pass WHERE user ='%s'",name(playerid));
	cache_get_row(0, 1, pInfo[playerid][pass]);

But it doesnt work and i get error message in mysql_log:

Код:

[21:23:02] [DEBUG] cache_get_field_content - row: 1, field_name: "pass WHERE user ='asd'", connection: 1, max_len: 1
[21:23:02] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('1')
[21:23:02] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[21:23:06] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM players WHERE user='asd' AND pass ='test'", callback: "checkpass", format: "i"
[21:23:06] [DEBUG] CMySQLQuery::Execute[checkpass] - starting query execution
[21:23:06] [DEBUG] CMySQLQuery::Execute[checkpass] - query was successfully executed within 0.270 milliseconds
[21:23:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:23:06] [DEBUG] Calling callback "checkpass"..
[21:23:06] [DEBUG] cache_get_field_content - row: 1, field_name: "pass WHERE user ='asd'", connection: 1, max_len: 1
[21:23:06] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('1')
[21:23:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[PT]

SELECT FROM

You need learn SQL.

[Vince]

I don't think you know how to write even the most basic of queries. And since you're one such selfish person who deletes his messages after he gets help, I can't be bothered. Learn some SQL first.