Participants list
$action = htmlspecialchars($_POST['act']); if (!$action) {$action = $_GET["act"];} $keywrd = trim(htmlspecialchars($_POST['keywrd'])); if (!$keywrd) {$keywrd = $_GET["keywrd"];} $direction = htmlspecialchars($_GET['dr']); $type = htmlspecialchars($_GET['type']); if (!$type) {$type = "surname";} ?> if ($keywrd) {echo "Search results on «".$keywrd."»
";} else {echo "";} ?> switch ($action) { case '1': $selrec = mysqli_query ($dbcnx, "SELECT * FROM tbl_participants WHERE surname LIKE '%$keywrd%' OR name LIKE '%$keywrd%' OR company LIKE '%$keywrd%' AND visible = 1 ORDER by ".$type." $direction;"); if ($direction == "asc") {$direction = "desc";} else {$direction = "asc";} break; case '2': if ($direction == "asc") { $selrec = mysqli_query ($dbcnx, "SELECT * FROM tbl_participants WHERE visible = 1 ORDER by ".$type." ASC;"); $direction = "desc"; } else { $selrec = mysqli_query ($dbcnx, "SELECT * FROM tbl_participants WHERE visible = 1 ORDER by ".$type." DESC;"); $direction = "asc"; } break; default: $selrec = mysqli_query ($dbcnx, "SELECT * FROM tbl_participants WHERE visible = 1 ORDER by surname ASC;"); $direction = "desc"; $action = "2"; } if ($selrec) { ?>
Last name | First name | Company | ||
---|---|---|---|---|
".$participants['surname']." | "; echo "".$participants['name']." | "; //echo "".$participants['position']." | "; echo "".$participants['company']." | "; //echo "".$participants['country']." |
Total records:
} ?> if ($rowcount == 0) {echo "No entries.
";$keywrd = "";} ?> if ($action=="1") {echo "";} ?> } ?>