db_process_query("select",$rgsTbl,"*","none","none","none"); // select everyone } else{ $db_CMS->db_process_query("select",$anbTbl,"*","none",$searchType." = '$searchValue'","none"); } $sRsltSet = $db_CMS->dbRsltSet ; $noOfParticipants = $db_CMS->dbNumRow; if ($db_CMS->dbNumRow > 0) { //ok these are people registered.. now find out details about them.. $rowCount = 0; // initialize a counter.. if ($searchValue==""){ while ($sCurRow_rgs = $db_CMS->db_fetch_array($sRsltSet)) { $anbID = $sCurRow_rgs["anbID"]; $pymID = $sCurRow_rgs["pymID"]; $cnfID = $sCurRow_rgs["cnfID"]; $db_CMS->db_process_query("select",$anbTbl,"*","none","anbID = '$anbID'","none"); $sRsltSet_anb = $db_CMS->dbRsltSet; $sCurRow_anb = $db_CMS->db_fetch_array($sRsltSet_anb); // list of column names to be displayed.. $colValue = array("LoginID","Title","FirstName","LastName","Email","Phone","View"); $rowValue[$rowCount][$colValue[0]] = $sCurRow_anb["athUserName"]; $rowValue[$rowCount][$colValue[1]] = $sCurRow_anb["anbTitle"]; $rowValue[$rowCount][$colValue[2]] = $sCurRow_anb["anbFName"]; $rowValue[$rowCount][$colValue[3]] = $sCurRow_anb["anbLName"]; $rowValue[$rowCount][$colValue[4]] = $sCurRow_anb["anbEmail"]; $rowValue[$rowCount][$colValue[5]] = $sCurRow_anb["anbPhone"]; $rowValue[$rowCount][$colValue[6]] = ""; $rowCount++; } } else{ while ($sCurRow_anb = $db_CMS->db_fetch_array($sRsltSet)) { // get the payment id from the registration table.. $anbID = $sCurRow_anb["anbID"]; $db_CMS->db_process_query("select",$rgsTbl,"*","none","anbID = '$anbID'","none"); $sRsltSet_rgs = $db_CMS->dbRsltSet; $sCurRow_rgs = $db_CMS->db_fetch_array($sRsltSet_rgs); $pymID = $sCurRow_rgs["pymID"]; // list of column names to be displayed.. $colValue = array("LoginID","Title","FirstName","LastName","Email","Phone","View"); // ok store the respective values... $rowValue[$rowCount][$colValue[0]] = $sCurRow_anb["athUserName"]; $rowValue[$rowCount][$colValue[1]] = $sCurRow_anb["anbTitle"]; $rowValue[$rowCount][$colValue[2]] = $sCurRow_anb["anbFName"]; $rowValue[$rowCount][$colValue[3]] = $sCurRow_anb["anbLName"]; $rowValue[$rowCount][$colValue[4]] = $sCurRow_anb["anbEmail"]; $rowValue[$rowCount][$colValue[5]] = $sCurRow_anb["anbPhone"]; $rowValue[$rowCount][$colValue[6]] = ""; $rowCount++; } } } // php codes ends .............................................................................. ?> "; echo ""; echo "

"; echo ""; echo ""; echo ""; echo ""; echo "

"; echo "".$noOfParticipants." Participant(s) found:"; echo "

"; echo ""; $colCount = count($colValue); // get the number of columns. echo ""; // create the column names... for ($count=0;$count<$colCount;$count++) { echo ""; } echo ""; // let's print their respective values........... $rowCount = count($rowValue); // get the number of columns. for ($countX=0;$countX<$rowCount;$countX++) { echo ""; for ($countY=0;$countY<$colCount;$countY++) { echo ""; } echo ""; } echo ""; echo ""; // php code ends here................................................... ?>

"; echo "$colValue[$count]"; echo "

"; echo "".$rowValue[$countX][$colValue[$countY]].""; echo "

"; echo " Participant lookup: "; echo "
"; echo " Search By: "; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "
"; echo " Hint: Leave the search field blank and click the \"search\" button to see all participants "; echo "