2. PHPRunner General questions
  3. [SOLVED]  Restrict search to public records
This topic is locked
[SOLVED]

 Restrict search to public records

 		9/1/2011 10:20:59 AM
PHPRunner General questions
T
 text author

Hi
Is there an easy way within phprunner to restrict search results to records that have a "public" field in a table.
Thanks
Richard
Sergey Kornilov admin 9/1/2011

You will need to modify SQL Query on SQL Query screen adding the following WHERE clause:

WHERE public=1


I assume that public field accepts 0 and 1 as values.
T
 		text author 9/2/2011



You will need to modify SQL Query on SQL Query screen adding the following WHERE clause:

WHERE public=1


I assume that public field accepts 0 and 1 as values.


Thanks Sergey, yes it does.
You guys rock.