"; while ($row = mysql_fetch_array($categories)) { $display .="".$row["categoryname"]."
\n"; } } elseif ($action == "edit") { $action = "update"; $formcall=""; $submitvalue = "Edit Title "; $pagetitle = "Make Edits"; if ($MOVIES = mysql_query(" SELECT ourmovies.Title, ourmovies.Media, ourmovies.Rating, ourmovies.runtime, ourmovies.Cover, ourmovies.Synopsis FROM ourmovies WHERE ourmovies.ID = '$a'")) { if (mysql_num_rows($MOVIES) > 0) { $title = mysql_result($MOVIES,0,"Title"); $format = mysql_result($MOVIES,0,"Media"); $rating = mysql_result($MOVIES,0,"Rating"); $runtime = mysql_result($MOVIES,0,"runtime"); $cover = mysql_result($MOVIES,0,"Cover");; $synopsis = mysql_result($MOVIES,0,"Synopsis"); } else { echo "Error: Title ($a) Not Found"; } if ($cover != '') { $coverdisplay .="$cover"; $coverdisplay .="
\n"; } else { $coverdisplay=""; } } if ($result = mysql_query(" SELECT categories.ID, categories.categoryname, moviesincategories.movieid FROM categories LEFT JOIN moviesincategories ON categories.ID = moviesincategories.catid AND moviesincategories.movieid = '$a' ORDER BY categories.categoryname")) { while ($row = mysql_fetch_array($result)) { if ($row["movieid"] == $a) { $checked = " CHECKED"; } else { $checked = ""; } $display .="".$row["categoryname"]."
\n"; } } } elseif ($action == "insert") { if ($cover_name != "") { @copy("$cover" , "/home/marian/public_html/images/covers/$cover_name"); // or die("Couldn't Upload Your File."); $cover="$cover_name"; } mysql_query( "INSERT into ourmovies SET Title = '$title', Media = '$format', Rating = '$Rating', Year = '$year', runtime = '$runtime', Cover = '$cover', Synopsis = '".addslashes($synopsis)."'"); $a=mysql_insert_id($linkid); if ($result = mysql_query( "SELECT ID, categoryname from categories order by categoryname" )) { while ($row = mysql_fetch_array($result)) { if ($$row['ID'] == "on") //insert into ArticlesInCategories { mysql_query("INSERT INTO moviesincategories SET catid='".$row['ID']."', movieid='$a'"); } } } else { $error= "Error: There is something wrong with the database query "; } header ("Location:http://www.spacerock.com/movies/admin/index.php"); exit; } elseif ($action == "update") { mysql_query("DELETE from moviesincategories WHERE movieid = '$a'"); //now let's put the categories currently selected in if ($result = mysql_query( "SELECT ID, categoryname from categories order by categoryname" )) { while ($row = mysql_fetch_array($result)) { if ($$row['ID'] == "on") //insert into ArticlesInCategories { mysql_query("INSERT INTO moviesincategories SET catid='".$row['ID']."', movieid='$a'"); } } if ($coverexists) { $cover ="$coverexists"; } else { @copy("$cover" , "/home/marian/public_html/images/covers/$cover_name"); // or die("Couldn't Upload Your File."); $cover="$cover_name"; } mysql_query( "UPDATE ourmovies SET Title = '$title', Media = '$media', Rating = '$rating', Year = '$year', runtime = '$runtime', Cover = $cover', Synopsis = '".addslashes($synopsis)."' WHERE ID = '$a'"); header ("Location:http://www.spacerock.com/movies/admin/index.php"); exit; } } } include ("/home/marian/public_html/mheader.txt"); print <<$pagetitle

Category:	$display
Title:
Format	DVD VHS
Year Rating: Runtime:	Synopsis: ENDTAG; $ab = new Editize; $ab->name = 'synopsis'; $ab->height = '300'; $ab->width = '100%'; $ab->paragraphstyles = TRUE; $ab->paragraphalignments = FALSE; $ab->bulletlists = FALSE; $ab->numberedlists = FALSE; $ab->hypermovies = FALSE; $ab->images = TRUE; $ab->tables = FALSE; $ab->basefontface = 'Verdana'; $ab->basefontsize = '12'; $ab->appletbgcolor = 'white'; $ab->codeview = TRUE; $ab->ns4support = TRUE; $ab->display($synopsis); print <<
Cover Art:	$coverdisplay

ENDTAG; print "
\n"; ?>