Mysql withdraw data problems...

Mysql withdraw data problems... - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql withdraw data problems... (/showthread.php?tid=518148)

Mysql withdraw data problems... - nedisor - 08.06.2014

Hello every one!!!!
I have a data base and I try to extract few things.

Код:

mysql_fetch_field_row(hsavingstring, "Name"); format(BusinessInfo[BusinessID][bName], 24, "%s", hsavingstring);
mysql_fetch_field_row(hsavingstring, "User"); format(BusinessInfo[BusinessID][bOwner], 24, "%s", hsavingstring);

With this 2 things I get Owner name and Business name.

Код:

format(bstring, sizeof(bstring), "Nume: %s \nOwner: %s\nBusiness ID: %d\nFee %d", BusinessInfo[BusinessID][bName], BusinessInfo[BusinessID][bOwner], BusinessID, BusinessInfo[BusinessID][bFeePrice]);

BusinessInfo[BusinessID][bLabel] = Create3DTextLabel(bstring, 0x21DD00FF, BusinessInfo[BusinessID][bEnterX], BusinessInfo[BusinessID][bEnterY], BusinessInfo[BusinessID][bEnterZ], 40.0, 0);

BusinessInfo[BusinessID][bPickup] = CreatePickup(1239, 23, BusinessInfo[BusinessID][bEnterX], BusinessInfo[BusinessID][bEnterY], BusinessInfo[BusinessID][bEnterZ], 0);

Now I create my 3dltextlabel/Pickup.

In debug found this:

Код:

8] >> mysql_fetch_field_row( Connection handle: 1 )

[18:17:58] CMySQLHandler::FetchField("Name") - Asdfasdfasdfsdf

So it extracts from MYSQL the name

BUT my problem is this one: http://postimg.org/image/rkd84nrg3/

In place of Asdfasdfasdfsdf (Business name) it shows "A", just first letter of name.

Re: Mysql withdraw data problems... - nedisor - 08.06.2014

Solved!!! I had a problem with BusinessID.