SA-MP Forums Archive
mysql BUG - 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 BUG (/showthread.php?tid=357886)



mysql BUG - oicq747285250 - 08.07.2012

Correctly:

with BUG:

DEBUG:


what happen!??
that is something wrong when
mysql_fetch_field with mysql_get_field or mysql_fetch_field_row together i've tried


Re: mysql BUG - Kirollos - 08.07.2012

What's wrong here?

Explain more your problem..


Re: mysql BUG - Knappen - 08.07.2012

Your pictures are just confusing.


Re: mysql BUG - oicq747285250 - 09.07.2012

I god results of field NO.1 after 'mysql_fetch_field'
when using mysql_get_field(field,result)
fields is correct but every result is from "char_id"
fieldNO.1:"char_id" 50 dtype=0(dtype=MYSQL_STYLE_INT)
fieldNO.2:"account_id" 0 dtype=0(dtype=MYSQL_STYLE_INT)
fieldNO.3:"nickname" "ssadfadf" dtype=2(dtype=MYSQL_STYLE_STR)
"....something field" dtype=...

without mysql_fetch_field it gots
mysql_get_field("nickname",result),dtype=2,result output: "ssadfadf"

with mysql_fetch_field it gots
mysql_get_field("nickname",result),dtype=2,result output: "50"
or:
mysql_fetch_field(2,no2fieldname)
mysql_get_field(no2fieldname,no2result) ((output:dtpye=2(means STRING),no2result="50"))


floats it gots
mysql_get_field("hp",result),dtype=1,result output: "50.000000"


dtype is correct because field is correct,but result is wrong!so i got int:50 str:50 or float:50.000000
............My BAD ENGLISH.