Simple problem ?
#1

hey guys i have this error in my mysql_log

Код HTML:
[ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM `others`")
Код HTML:
gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `safes`");
	mysql_tquery(handle, gQuery, "LoadSafes", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `zones`");
	mysql_tquery(handle, gQuery, "LoadZones", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `houses`");
	mysql_tquery(handle, gQuery, "LoadHouses", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `cars`");
	mysql_tquery(handle, gQuery, "LoadCar", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `housefurnitures`");
	mysql_tquery(handle, gQuery, "LoadFurnitures", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `business`");
	mysql_tquery(handle, gQuery, "LoadBusiness", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `clans`");
	mysql_tquery(handle, gQuery, "LoadClans", "");

        gQuery[0] = (EOS);
        mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `dsveh`");
	mysql_tquery(handle, gQuery, "LoadDSVeh", "");

	gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `others`");
	mysql_tquery(handle, gQuery, "LoadOthers", "");
Код HTML:
function LoadOthers()
{
	new rows, fields;
	cache_get_data(rows, fields, handle);

	new tmp[128];
	cache_get_field_content(0, "Tax", tmp);			Tax = strval(tmp);
	cache_get_field_content(0, "Charity", tmp);		CharityMoney = strval(tmp);
	return 1;
}
what is wrong why i get that error ?
Reply
#2

There are no rows in the table `others`
Reply
#3

thx it worked
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)