simphiwecharles

Good day,

Thank you so so much, it finally works as expected. I’m so excited. I’m gonna give your work all the stars. I will also do some recommendation.

Kind regards,
Simphiwe

Good day,

It sort of works now but there is one slight problem, when the data is queried from the database and displayed on the table, it is some how wrong. user-1’s data is displayed when user2 is logged in. same story if i login with the other user. But i think we are really close now to find the solution.

secondly, please correct me if I am wrong, but $user_id has to do with access control (admin, contributor, etc). So, wouldn’t it maybe work better if used ID(on the first column, which is auto-incremented). at that case it will always be unique to that particular person. link – https://take.ms/viPht

I hope I am not causing too much unnecessary work for you.

Kind regards,
Simphiwe

Good day,

I tried that query and afraid to say, but i got the same error. I’m really confused now.

Thank you for trying to help, though. ??

regards,
Simphiwe

Hello Ian,

I do have the latest version of WPTable, and here is my setup. – https://take.ms/laFQg

I hope it is helpful because I am really confused right now.

Kind regards,
Simphiwe

Hi Ian

i did try $user_id but im getting an error Invalid query. Please check the syntax and try again.

and another thing, where can i modify the mysql filter?

kind regards,
Simphiwe