'1000' AND (`authorizeNetTransID`!='' OR `Payment_status_for_check`='2' OR `Payment_status_for_banktransfer`='2' OR `waived`='1' OR `Pay_local`='1') ORDER BY `uid`"; break; case "Last Name": $sqlstr=" WHERE `uid`> '1000' AND (`authorizeNetTransID`!='' OR `Payment_status_for_check`='2' OR `Payment_status_for_banktransfer`='2'OR `waived`='1' OR `Pay_local`='1') ORDER BY `usr_last_name`"; break; case "usr_country": $sqlstr=", `tb_conf_usr` WHERE `tb_conf_usr_fee`.`uid` =`tb_conf_usr`.`uid` AND `tb_conf_usr_fee`.`uid`> '1000' AND (`tb_conf_usr_fee`.`authorizeNetTransID`!='' OR `tb_conf_usr_fee`.`Payment_status_for_check`='2' OR `tb_conf_usr_fee`.`Payment_status_for_banktransfer`='2' OR `tb_conf_usr_fee`.`waived`='1' OR `tb_conf_usr_fee`.`Pay_local`='1') ORDER BY `tb_conf_usr`.`usr_country`, `tb_conf_usr`.`usr_last_name`"; break; default: $sqlstr=" WHERE `uid`> '1000' AND (`authorizeNetTransID`!='' OR `Payment_status_for_check`='2' OR `Payment_status_for_banktransfer`='2' OR `waived`='1' OR `Pay_local`='1') ORDER BY `uid`"; } $conn = new mysqli($mysqli_server_name, $mysql_username, $mysql_password, $mysql_database); if ($mysqli->connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt = $conn->prepare("SELECT * FROM `tb_conf_usr_fee` $sqlstr "); $stmt->execute(); $result = $stmt->get_result(); $stmt->close(); //Have to run a second query on the database to determine the number of counties $stmt2 = $conn->prepare("SELECT * FROM `tb_conf_usr_fee` $sqlstr "); // "s" means the database expects a string $stmt2->execute(); $result2 = $stmt2->get_result(); $stmt2->close(); //While loop to determine the number of counties while($row2 = $result2->fetch_assoc()) { $temp = $row2["usr_country"]; //country to compare to the list of countries already present $size=1000; //get the size of the array $boolean = "false"; //boolean to determine if the number of countrys should be incremented for($x = 0; $x<$size; $x++) //for loop that runs through the current list of countries { if($temp==$country[$x]) //if the country is already in the list then set the boolean true { $boolean="true"; } } if($boolean=="false") //if the country isnt in the list then increment the counter and number of countries. { $i++; $country[$i]=$temp; $numberOfCountry++; } } //Must do a third query to query the database that tells if the abstract is aproved. //Must pull out author and then compare to author $stmt3 = $conn->prepare("SELECT * FROM `tb_conf_abstract` ;") ; $stmt3->execute(); $result3 = $stmt3->get_result(); ?> fetch_assoc()) { $stm22 = $conn->prepare("SELECT * FROM `tb_conf_usr` WHERE `uid`=" . $row["uid"]); $stm22->execute(); $result22 = $stm22->get_result(); $row22=$result22->fetch_assoc(); /* while($row3=mysql_fetch_array($result3)) { //Find the correct author in the abstract table. if($row["uid"] ==$row3["abs_author_id"]) { if($row3["abs_ss_status"]=="A") { $showAbs="yes"; } else { $showAbs="no"; } } } */ ?> close(); ?>
Reg. No
NAME
AFFILIATION
COUNTRY