Mysql withdraw data problems...
#1

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.
Reply
#2

Solved!!! I had a problem with BusinessID.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)