01.05.2010, 11:06
Hi,
i have a problem with MySQL ...
My Code:
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 .....
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); }
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 .....