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 "