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); ?>
| ID | Title | User | Approve | |
|---|---|---|---|---|
| =$row["id"]?> | ">=$row["title"]?> | ">=$database->database_result($database->database_query("SELECT user_username FROM se_users WHERE user_id='".$row["user"]."'"),0)?> | ">=$database->database_result($database->database_query("SELECT user_email FROM se_users WHERE user_id='".$row["user"]."'"),0)?> | ">View | if($row["approved"]==1){?>&approve=0">Unapprove }else{?>&approve=1">Approve }?> | &delete=delete" onclick="javascript:return confirm('Are you sure you want to delete this entry?');">Delete |