How to use skellett mysql (Select)?

[pepper82]

Hi all,
I have this:

                    set {_result} to mysql result of query "SELECT * FROM `{@table}` WHERE `username`='%{_p}%';"
                    set {_test::*} to mysql string "date" in {_result}
                    set {_test1::*} to mysql string "username" in {_result}

{_test::*} contains the date but {_test1::*} is empty and I don't know why. Do you really need to do 2 seperate SELECTs??

 

[TPGamesNL]

Can you show the contents from your database? Also, you're getting the values with a username filter, why would you still want to get the username values?

 

[pepper82]

Limeglass confirmed you need to make new query for every new value you wanna grab from the table ...

 

[TPGamesNL]

Where did he say that?

 

[pepper82]

Discord