SA-MP Forums Archive
Help from MySQL - Inquiry in Inquiry - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Help from MySQL - Inquiry in Inquiry (/showthread.php?tid=145183)



Help from MySQL - Inquiry in Inquiry - ColderPL - 01.05.2010

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 .....