[khRamin78]

hey guys i know a little SQL but i have problems with MYSQL plugin of samp functions

like

PHP код:

new Cache:result = mysql_query(Handel,string);
    row=cache_get_row_count(Handel); // warning 202: number of arguments does not match definition (i tried () too but nothing changes 
    if(row == 1) 


also i have problem with getting rows of result :S will i check just result = 1 or i have to use cache_get_row_count ?

if you find any good tut for this new plugin ill +rep u tnx guys

[Banditul18]

Which version of MySQL are you using (or try to use)?

[khRamin78]

Quote:

Originally Posted by Banditul18 Which version of MySQL are you using (or try to use)?

blueg's plugin
this one

[Banditul18]

Well you need to be little more specific , there two versions , r33+ or r40+ , this two are different

For r33+:
https://sampwiki.blast.hk/wiki/MySQL/R33..._get_row_count

For r40+:
https://sampwiki.blast.hk/wiki/MySQL/R40..._get_row_count

For this versions, the parameters of function differ

And the check depends , if you only expect to select only one row from databse , then yes is correct , but if there is more rows you need to change to

Код:

if(row > 0)

[khRamin78]

Quote:

Originally Posted by Banditul18 Well you need to be little more specific , there two versions , r33+ or r40+ , this two are different For r33+: https://sampwiki.blast.hk/wiki/MySQL/R33..._get_row_count For r40+: https://sampwiki.blast.hk/wiki/MySQL/R40..._get_row_count For this versions, the parameters of function differ And the check depends , if you only expect to select only one row from databse , then yes is correct , but if there is more rows you need to change to Код: if(row > 0)

oh tnx