include("include/session.php"); ?>
function delete_record($eventid,$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 event_app where eventid=$eventid and userxml='$userxml'";
mysql_query($sql);
/* mysql_close(); */
echo " "; $num=mysql_numrows($result); $i=0; while ($i < $num) { $event_name=mysql_result($result,$i,"event_name"); $short_description=mysql_result($result,$i,"short_description"); $description=mysql_result($result,$i,"description"); $details=mysql_result($result,$i,"details"); $start_date=mysql_result($result,$i,"start_date"); $end_date=mysql_result($result,$i,"start_date"); $eventid=mysql_result($result,$i,"eventid"); $serv= htmlentities($_SERVER['PHP_SELF']); echo "$event_name $short_description $description $details Start Dates $start_date End Date $end_date "; 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') { $eventid = $_GET['eventid']; $userxml= $session->username; delete_record($eventid,$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"; } ?> } ?> |