Help from MySQL - Inquiry in Inquiry
#1

Hi,
i have a problem with MySQL ...
My Code:
Код:
new pol[128];
format(pol, sizeof(pol), "SELECT `nazwap`,`sztuki`,`kordyX`,`kordyY`,`kordyZ`,`uidp` FROM `przedmioty` WHERE `wlasciciel` = 'Brak'");
mysql_query(pol);
mysql_store_result();
while(mysql_fetch_row_data())
{
new Przed[64];
new Data[64];
new Sztuki[64];
new Sz;
new uid;
new Float:x,Float:y,Float:z;
mysql_fetch_field("kordyX", Data);
x = floatstr(Data);
mysql_fetch_field("kordyY", Data);
y = floatstr(Data);
mysql_fetch_field("kordyZ", Data);
z = floatstr(Data);
mysql_fetch_field("nazwap", Data);
mysql_fetch_field("sztuki", Sztuki);
Sz = strval(Sztuki);
mysql_fetch_field("uidp", Sztuki);
uid = strval(Sztuki);
format(Przed, sizeof(Przed), "%s(%d)",Data,Sz);
new Text3D:idlabla;
idlabla = Create3DTextLabel(Przed,COLOR_WHITE,x,y,z,10.0,0,1);
new update[256];
format(update, sizeof(update), "UPDATE `gracze`.`przedmioty` SET `idlabla` = '%d' WHERE `uidp` = '%d'",_:idlabla,uid);
printf(update);
mysql_query(update);
}
My trouble this:
When First Inquiry is working, then i must do second Inquiry and memory from first Inquiry is delete ;/
Pls help ;(
And Sory from my bad english but I write with Gooogle Translate .....
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)