MYSQL PROBLEMS
#1

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
Reply
#2

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

Quote:
Originally Posted by Banditul18
Посмотреть сообщение
Which version of MySQL are you using (or try to use)?
blueg's plugin
this one
Reply
#4

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)
Reply
#5

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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)