how to replace STRING in forms in SQL browse with a variable

[honza1965]

Please nice - I have one FORM and I need to select data depending on the different values of the variable. How to insert a variable from PHP into this BROWSE? ? ? This is the variable nu_user_name. Thanks for the feedback

[kev1n]

Hi,

The Hash Cookie #USER_ID# contains the User ID.
Add a JOIN to the table zzzzsys_user and place in the WHERE clause a filter on the zzzzsys_user_id.

Example:

Code: Select all

SELECT * FROM your_table
LEFT JOIN zzzzsys_user ON sus_name = your_table_user_name
WHERE (zzzzsys_user_id = '#USER_ID#')

[honza1965]

dear Kevin1 - thank you very much for your advice - everything works as I needed. You helped an old IT worker. I first started living as an IT in 1987, but now I have been on a disability pension for 15 years. Sometimes, however, I need to make an application for friends as my hobby, but my knowledge is already small ... You helped me very professionally and colleagues. Hats off not only for your knowledge, but also for your willingness to help an unknown colleague! ! ! Thanks Honza Nachtigal