Houses not loading after restart svr(Mysql)
#3

Quote:
Originally Posted by Kampott
Посмотреть сообщение
You guys have problems in your sql syntax cuz you forget the apostrophes
Код:
stock LoadHouses()
{
    mysql_function_query(g_SQL_handle, "SELECT `int_name`,`intx`,`inty`,`intz`,`inta`,`cpx`,`cpy`,`cpz`,`interior`,`value` FROM `interiors`", true, "LoadHouseInteriorData", "");
	mysql_function_query(g_SQL_handle, "SELECT `house_id`,`hname`,`howner`,`hlocation`,`hpass`,`x`,`y`,`z`,`a`,`cpx`,`cpy`,`cpz`,`hvalue`,`hstorage`,`hint`,`hprivacy`,`hforsale` FROM `houses` ORDER BY `house_id`", true, "LoadHouseData", "");
}
To not get errors anymore, try executing code in your phpmyadmin console before pasting it into your samp code
You don't need apostrophes for fields, only single quotes ( ' ) for strings.
Reply


Messages In This Thread
Houses not loading after restart svr(Mysql) - by Stop - 16.09.2017, 02:39
Re: Houses not loading after restart svr(Mysql) - by Kampott - 16.09.2017, 09:51
Re: Houses not loading after restart svr(Mysql) - by Dignity - 16.09.2017, 10:18
Re: Houses not loading after restart svr(Mysql) - by Kampott - 16.09.2017, 12:45

Forum Jump:


Users browsing this thread: 1 Guest(s)