This topic is locked
[SOLVED]

 query before viewing a page

4/24/2018 5:36:11 PM
PHPRunner General questions
P
PaulM author

I want to show only records that belong to a branch of the company by default but would also like to select other branches to see their records if I need to.
My question is what is the best way of doing this? I have the username currently attached to a branch but can't think of the best way or how to set up a query to select other branches.

admin 4/24/2018

Check this article:

https://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
You can modify WHERE clause on the fly based on some condition.

P
PaulM author 4/25/2018



Check this article:

https://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm
You can modify WHERE clause on the fly based on some condition.


Thanks... solved