Thank you, Jason. That makes sense. But two followup questions.
First, I selected the record set and moved it after line 6
<?php require_once('Connections/residents_unix.php'); ?> and before what used to be line 7
<?php require_once( "WA_SecurityAssist/Helper_PHP.php" ); ?>
but now I get the error:
Fatal error: Call to undefined function getsqlvaluestring() in /data/25/2/98/45/2424045/user/2657060/htdocs/test/directory_detail2.php on line 13
Line 13 is
$query_rs_directory_detail = sprintf("SELECT * FROM Residents WHERE ID = %s", GetSQLValueString($colname_rs_directory_detail, "int"));
Not sure what to do now.
The second thing I will need to know to get this to work properly, is how to have the first group of data Show If the "If Self" OR the "If Admin" rules are met. I'm not sure how to string those together in php. Can I do it by
<?php if(WA_Auth_RulePasses("If Self") OR WA_Auth_RulePasses("If Admin")){ // Begin Show Region ?>
And can I still have a second Show If Admin within that group that will only show the Group field if you are Admin?
I've attached the file if it helps.
Thank you.