database_query("DELETE FROM contest WHERE id='".$database->database_real_escape_string($_GET["id"])."'"); $_GET["id"]=0; } if($_GET["approve"]==1) { $database->database_query("UPDATE contest SET approved=1 WHERE id='".$database->database_real_escape_string($_GET["id"])."'"); $_GET["id"]=0; } if($_GET["approve"]=="0") { $database->database_query("UPDATE contest SET approved=0 WHERE id='".$database->database_real_escape_string($_GET["id"])."'"); $_GET["id"]=0; } if($_GET["id"]>0) { $query=$database->database_query("SELECT * FROM contest WHERE id='".$database->database_real_escape_string($_GET["id"])."'"); $row=$database->database_fetch_array($query); ?>

By: ">database_result($database->database_query("SELECT user_username FROM se_users WHERE user_id='".$row["user"]."'"),0)?>

&approve=0">Unapprove&approve=1">Approve

database_query("SELECT * FROM contest WHERE file!='' ORDER BY id DESC"); while($row=$database->database_fetch_array($query)) { ?>
IDTitleUserEmailApprove
">">database_result($database->database_query("SELECT user_username FROM se_users WHERE user_id='".$row["user"]."'"),0)?> ">database_result($database->database_query("SELECT user_email FROM se_users WHERE user_id='".$row["user"]."'"),0)?> ">View | &approve=0">Unapprove&approve=1">Approve | &delete=delete" onclick="javascript:return confirm('Are you sure you want to delete this entry?');">Delete