Maybe someone can help me with this...

abie10

Maybe someone can help me with this. The code is here:

<html>

<body>
Latest Submissions
<?php

$db = mysql_connect("localhost", "abie10", "abie10");

mysql_select_db("pea_abie10_com",$db);

// display individual record

if ($id) {

$result = mysql_query("SELECT * FROM submit WHERE id=$id",$db);

$myrow = mysql_fetch_array($result);

printf("Wrestlers Name: %s\n ", $myrow["wname"]);

printf("Category: %s\n ", $myrow["category"]);

printf("Submitted By: %s\n ", $myrow["name"]);

printf("Email: %s\n ", $myrow["email"]);

} else {

// show employee list

$result = mysql_query("SELECT * FROM submit",$db);

if ($myrow = mysql_fetch_array($result)) {

// display list if there are records to display

do {

printf("<a href=\"%s?id=%s\">%s </a> \n", $PHP_SELF, $myrow["id"], $myrow["wname"]);

} while ($myrow = mysql_fetch_array($result));

} else {

// no records to display

echo "Sorry, no records were found!";

}

</body>

</html>

What I need to do is this. This is basically a lite admin page. It will display submissions from users, which are basically nominations. They are stored in a DB and displayed on this page. The admin will come in and view them all and make a determination as to accept the nominee or not. The admin can click on each submission and view the info. From there, I need a link such as Accept and Reject options to the admin. If he rejects it, it will simply be removed from the DB. If he accepts it, it will be removed from the 'submit' database and added to a db called nominees.

This is the part of the code that is giving me hell. I already have most of the simple stuff complete.

If anyone can help me please email me at abie@abie10.com or respond here.

benbox

Ive just reorganised the main listing bit for you, made it a lot simpler....

<html>

<body>

Latest Submissions
<?
$db = mysql_connect("localhost","abie10","abie10");
mysql_select_db("pea_abie10_com",$db);

// display individual record

if (isset($id)) {

$result = mysql_query("SELECT FROM submit WHERE id = $id");
while ($myrow = mysql_fetch_array($result)) {
$id = $myrow["id"] ; // im guessing you have an ID field, if not you will need one to keep it easy
$wname = $myrow["wname"] ;
$cat = $myrow["category"] ;
$name = $myrow["name"] ;
$email = $myrow["email"] ;

echo "Name: $wname
      Category: $cat
      Name: $name
      E-mail: <a href=mailto:$email>$email</a>
      Admin options: <a href=varify.php?id=$id>Varify</a> | <a href=remove.php?id=$id>Remove</a>

      <hr>
      "

      $found_wrestlers = 1 ;
}

}

if($found_wrestlers!=1) {
echo "Sorry, no records were found!";
}
?>

</body>
</html>

As you can see you will need more files (easier than all in one if it annoys you a lot !!)..
another file.. e.g. varify.php
the link passes the id variable into this file..
where you can either add it to another 'finalised' table in the database and remove it from the temporary.. or remove it from the temorary...

alternatively .. you could have an extra field in the table.... say for e.g. called 'varified'.. default is 0, but when it is varified the script makes this a 1...
e.g. mysql_query("UPDATE tablename SET varified = 1 WHERE id = $id") ;

simular thing for the delete... but you have DELETE FROM tablename WHERE id = $id....

and with both..

if(!isset($id)) { // if id is not set
print "You did not specify a wrestler to alter" ;
}

or something along those lines....

hope this helps!
post or email me (ben.box@everything-to-do-with-it.co.uk) if you need ne more help