db_process_query("select",$rgsTbl,"*","none","$cndValue","$orderBy"); $sRsltSet_rgs = $db_CMS->dbRsltSet; if ($db_CMS->dbNumRow > 0) { //ok there are people registered.. now find out details about them.. // list of coloumn names to be displayed.. $colValue = array("ID%","Title%","First Name%","Last Name%","Email%","Institution%"); while ($sCurRow_rgs = $db_CMS->db_fetch_array($sRsltSet_rgs)) { $rgsID = $sCurRow_rgs["rgsID"]; $anbID = $sCurRow_rgs["anbID"]; $rgsTagAddress = $sCurRow_rgs["rgsTagAddress"]; // look up personal information for now.. $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); // ok store the respective values... $rowValue[$rowCount][$colValue[0]] = $rgsID; $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]] = $rgsTagAddress."%"; $rowCount++; } } ?> "; // create the coloumn names... for ($count=0;$count<$colCount;$count++) { echo ""; } echo ""; // lets print their respective values........... if (count($rowValue) > 0) { reset($rowValue); $countX = 0; while (list($key,$value) = each($rowValue)) { echo ""; for ($countY=0;$countY<$colCount;$countY++) { if ($rowValue[$key][$colValue[$countY]] == "") { $rowValue[key][$colValue[$countY]] = " "; } echo ""; } $countX++; // increment the row counter... echo ""; } } // php... ends.. ?>

Participant Administration

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

"; echo ""; switch ($countY) { case 0 : echo $countX+1; echo "%"; break; default : echo $rowValue[$key][$colValue[$countY]]; } echo ""; echo "