Help with my sql format code
#3

Код:
CMD:sandelys(playerid)
{
	new query[500];
 	format(query, sizeof(query), "SELECT * FROM `Logai1` ORDER BY `ID` DESC limit 10");
	mysql_query(query);
	mysql_store_result();
	new x, str[120], strf[1100];
	while(mysql_retrieve_row())
	{
	new KoksVardas[24], Koksivykis[50], Aridejo[5], Data[30];
	x ++;
	mysql_fetch_field_row(KoksVardas, "Vardas");
	mysql_fetch_field_row(Koksivykis, "Ivykis");
	mysql_fetch_field_row(Aridejo, "Idejo");
	mysql_fetch_field_row(Data, "Date");
	format(str, 300, "{00ff00}%s, %s %s\n",KoksVardas, Koksivykis, Data); strcat(strf, str);
	ShowPlayerDialog(playerid, 2525, DIALOG_STYLE_LIST, "Sandelio Logai", strf, "Aiљku", "");
	}
	mysql_free_result();
	return 1;
}
This command worked for me. Had headace for 2 nights :/
Reply


Messages In This Thread
Help with my sql format code - by mokinys98 - 17.04.2018, 12:31
Re: Help with my sql format code - by mokinys98 - 19.04.2018, 11:22
Re: Help with my sql format code - by mokinys98 - 19.04.2018, 20:37

Forum Jump:


Users browsing this thread: 1 Guest(s)