//connect to database
$conn = mysql_connect("mysql97.secureserver.net", "james438", "errorc438") or die(mysql_error());
mysql_select_db("james438",$conn) or die(mysql_error());
if ($_POST[op] != "delete") {
//haven't seen the form, so show it
$display_block = "
Select an Entry
";
//get parts of records
$get_list = "SELECT ID,title FROM anime_review";
$get_list_res = mysql_query($get_list) or die(mysql_error());
if (mysql_num_rows($get_list_res) < 1) {
//no records
$display_block .= "Sorry, no records to select!
";
} else {
//has records, so get results and print in a form
$display_block .= "
";
}
} else if ($_POST[op] == "delete") {
//check for required fields
if ($_POST[sel_reviewID] == "") {
header("Location: selectentry.php");
exit;
}
//get master_info
$recs_title = "SELECT title FROM anime_review WHERE ID = $_POST[sel_reviewID]";
$get_master = "SELECT violence FROM anime_review WHERE ID = $_POST[sel_reviewID]";
$get_master_res = mysql_query($recs_title);
$title1 = mysql_result($get_master_res, 'title');
$display_block = "Showing review for $title1.
";
//get all info
$get_addresses =
"SELECT ID, image, title, violence, sex_nudity, language,
runtime_episodes, overall_rating, artwork, story, comments, va_english, va_japanese,
genre, extras, review_date, basic_premise, summary, conclusion, publisher, website, where_found,
copyright, author, try_this
FROM anime_review
WHERE ID = $_POST[sel_reviewID]";
$get_addresses_res = mysql_query($get_addresses);
if (mysql_num_rows($get_addresses_res) > 0) {
$display_block .= "";
while ($add_info = mysql_fetch_array($get_addresses_res)) {
$ID = $add_info[ID];
$image = $add_info[image];
$title = $add_info[title];
$violence = $add_info[violence];
$sex_nudity = $add_info[sex_nudity];
$language = $add_info[language];
$runtime_episodes = $add_info[runtime_episodes];
$overall_rating = $add_info[overall_rating];
$artwork = $add_info[artwork];
$story = $add_info[story];
$comments = $add_info[comments];
$va_english = $add_info[va_english];
$va_japanese = $add_info[va_japanese];
$genre = $add_info[genre];
$extras = $add_info[extras];
$review_date = $add_info[review_date];
$basic_premise = $add_info[basic_premise];
$summary = $add_info[summary];
$conclusion = $add_info[conclusion];
$publisher = $add_info[publisher];
$website = $add_info[website];
$where_found = $add_info[where_found];
$copyright = $add_info[copyright];
$author = $add_info[author];
$try_this = $add_info[try_this];
$display_block .= "ID: $reviewID
Image: $image
Title: $title
Violence: $violence
Sex/Nudity: $sex_nudity
Language: $language
Runtime Episodes: $runtime_episodes
Overall Rating:
$overall_rating
Artwork: $artwork
Story: $story
Comments: $comments
Voice Acting English:
$va_english
Voice Acting Japanese: $va_japanese
Genre: $genre
Extras: $extras
Date Reviewed:
$review_date
Basic Premise: $basic_premise
Summary: $summary
Conclusion: $conclusion
Publisher: $publisher
Website: $website
Where Found: $where_found
Copyright: $copyright
Author: $author
Try This: $try_this";
}
$display_block .= "";
}
//get all email
// $r="showing review for $display_name";
$get_email = "SELECT title FROM anime_review WHERE ID = $_POST[sel_reviewID]";
$get_email_res = mysql_query($get_email);
if (mysql_num_rows($get_email_res) > 0) {
$display_block .= "Title:
";
while ($email_info = mysql_fetch_array($get_email_res)) {
$email = $email_info[title];
$email_type = $email_info[title];
$display_block .= "$email";
}
$display_block .= "";
}
$display_block .= "
select another
";
}
?>
My Records
print $display_block;
print "$r";
?>