Load business from MYSQL
#1

Well i dont know why this doesnt work. (i am loading loadbizz with loop for(new b...))

Код:
public LoadBizz(bizz)
{
	new query[128];
	new Data[1024];
	new Field[18][32];
	format(query, sizeof(query), "SELECT * FROM business WHERE BizzID = '%d' LIMIT 1", BizzInfo[bizz][bID]);
	mysql_query(query);
	mysql_store_result();
	if (mysql_fetch_row(Data, "|"))
 	{
 	  split(Data, Field, '|');
	  strmid(BizzInfo[bizz][bBizz], Field[0], 0, strlen(Field[0]), 255);
	  BizzInfo[bizz][bOwned] = strval(Field[1]);
	  strmid(BizzInfo[bizz][bOwner], Field[2], 0, strlen(Field[2]), 255);
		BizzInfo[bizz][bPickupX] = floatstr(Field[3]);
		BizzInfo[bizz][bPickupY] = floatstr(Field[4]);
		BizzInfo[bizz][bPickupZ] = floatstr(Field[5]);
		BizzInfo[bizz][bBizX] = floatstr(Field[6]);
		BizzInfo[bizz][bBizY] = floatstr(Field[7]);
		BizzInfo[bizz][bBizZ] = floatstr(Field[8]);
		BizzInfo[bizz][bInterior] = strval(Field[9]);
		BizzInfo[bizz][bSell] = strval(Field[10]);
		BizzInfo[bizz][bFee] = strval(Field[11]);
	  BizzInfo[bizz][bOpen] = strval(Field[12]);
		BizzInfo[bizz][bPickup] = strval(Field[13]);
		BizzInfo[bizz][bID] = strval(Field[14]);
		BizzInfo[bizz][bProducts] = strval(Field[15]);
		BizzInfo[bizz][bMaxProducts] = strval(Field[16]);
		printf("BizzID: %d",BizzInfo[bizz][bID]);
	}
	mysql_free_result();
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)