How to read the contents of a row in MySQL?
#1

Title says it all.
Reply
#2

Euh you just loop the row and if you use the R39 plugins look at this :

https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_data
Reply
#3

Quote:
Originally Posted by Jabern
Посмотреть сообщение
Euh you just loop the row and if you use the R39 plugins look at this :

https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_data
But why do I need to loop? If I just send a query to look for the salt of a specific user, there would only be 1 row, but what function should I use in order to retrieve the content of the row and convert it into a string in PAWN
Reply
#4

Depends on what plugin you're using, i use strickenkids, i can explain you for that...
Reply
#5

I am using Blue G's MySQL Plugin, https://sampforum.blast.hk/showthread.php?tid=56564
Reply
#6

Quote:
Originally Posted by EtayJ
Посмотреть сообщение
But why do I need to loop? If I just send a query to look for the salt of a specific user, there would only be 1 row, but what function should I use in order to retrieve the content of the row and convert it into a string in PAWN
Ahhhh ... you should use :

PHP код:
cache_get_field_content(row"field_name[]"); 
Reply
#7

Quote:
Originally Posted by Jabern
Посмотреть сообщение
Ahhhh ... you should use :

PHP код:
cache_get_field_content(row"field_name[]"); 
Thanks But I get an undenfined symbol error.
PHP код:
Untitled.pwn(417) : error 017undefined symbol "cache_get_field_content" 
Reply
#8

Quote:
Originally Posted by EtayJ
Посмотреть сообщение
Thanks But I get an undenfined symbol error.
Can you gave me the error ?
Reply
#9

What version of Mysql you use ?
Reply
#10

MySQL plugin or MySQL?
That's the plugin version R6
plugin-R6-win32_vs9 (that's the name of the file)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)