include("include/session.php"); ?>
function delete_record($question_id,$userxml) {
/* $username="root";
$password="";
$data="trivia";
$eventid = $_POST['eventid']; // Delete Key
mysql_connect(localhost,$username,$password);
mysql_select_db($data) or die( "Unable to select database"); */
$sql="DELETE FROM mytrivia where question_id=$question_id and userxml='$userxml'";
mysql_query($sql);
/* mysql_close(); */
echo " "; $num=mysql_numrows($result); $i=0; while ($i < $num) { $question_id=mysql_result($result,$i,"question_id"); $title=mysql_result($result,$i,"title"); $question=mysql_result($result,$i,"question"); $answer1=mysql_result($result,$i,"answer1"); $answer2=mysql_result($result,$i,"answer2"); $answer3=mysql_result($result,$i,"answer3"); $answer4=mysql_result($result,$i,"answer4"); $correct=mysql_result($result,$i,"correct"); $serv= htmlentities($_SERVER['PHP_SELF']); echo "$title Trivia Question $question Answer 1:$answer1 Answer 2:$answer2 Answer 3:$answer3 Answer 4:$answer4 Correct Answer :$correct "; echo " ![]() ![]() '; $i++; } } /* User has already logged in, so display relavent links, including * a link to the admin center if the user is an administrator. */ if($session->logged_in){ $userxml= $session->username; include("icons/header.php"); echo "Welcome $session->username, you are logged in."; if($session->isAdmin()){ echo "[Admin Center] "; } if($_GET['run'] == 'delete_record') { $question_id = $_GET['questionid']; $userxml= $session->username; delete_record($question_id,$userxml); } showlist($userxml); /*****/ if($session->isAdmin()){ echo "[Admin Center] "; } } else{ ?> /** * User not logged in, display the login form. * If user has already tried to login, but errors were * found, display the total number of errors. * If errors occurred, they will be displayed. */ if($form->num_errors > 0){ echo "".$form->num_errors." error(s) found"; } ?> } ?> |