connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt = $conn->prepare("SELECT * FROM `tb_conf_ss` WHERE `ss_id`=?"); // "s" means the database expects a string $stmt->bind_param("s", $id); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); $stmt->close(); $conn->close(); ?>
Special Session
Organizer(s):
Introduction:
connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt = $conn->prepare("SELECT * FROM `tb_conf_abstract` , `tb_conf_usr`, `tb_conf_usr_fee` WHERE `tb_conf_abstract`.`abs_author_id` = `tb_conf_usr`.`uid` AND `tb_conf_usr`.`uid` = `tb_conf_usr_fee`.`uid` AND `tb_conf_abstract`.`abs_category` = 'SS'AND `tb_conf_abstract`.`abs_special_session` =? AND `tb_conf_abstract`.`abs_ss_status`='A' AND `tb_conf_usr_fee`.`paid`!='5'"); // "s" means the database expects a string $stmt->bind_param("s", $id); $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); $stmt->close(); $conn->close(); if (@mysqli_num_rows($result)>0) { while($row=mysqli_fetch_array($result)) { switch ($row["abs_ss_status"]) { case A; $status="Approved"; break; case N; $status="New"; break; case D; $status="Declined"; break; } ?>

List of abstracts                                       Go Back