2. PHPRunner General questions
  3. [SOLVED]  query before viewing a page
This topic is locked
[SOLVED]

 query before viewing a page

 		4/24/2018 17:36:11
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.
Sergey Kornilov 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