";
if($_GET["delete"]) {
$gid = $_GET["delete"];
if($_GET["confirm"] == "yes")
{
$result5 = dbquery("SELECT genre FROM ".TABLEPREFIX."fanfiction_genres WHERE gid = '$gid'") or die(_FATALERROR."Query: SELECT genre FROM ".TABLEPREFIX."fanfiction_genres WHERE gid = '$gid' Error: (".mysql_errno( ).") ".mysql_error( ));
$genres = dbassoc($result5);
$newquery5 = dbquery("SELECT * FROM ".TABLEPREFIX."fanfiction_stories WHERE gid LIKE '%$genres[genre]%'") or die(_FATALERROR."Query: SELECT * FROM ".TABLEPREFIX."fanfiction_stories WHERE gid LIKE '%$genres[genre]%' Error: (".mysql_errno( ).") ".mysql_error( ));
while($genreresult = dbassoc($newquery5))
{
$tok = strtok($genreresult[gid], ", ");// tokenize the old list of names
$newString = "";// the new list of good names
while($tok)
{
if( $tok != $genres[genre] )// oldname is the thing that is going away
{
// It's a keeper, so decide if it is first or not for comma-age, then add it in
if( $newString != "" )
$newString .= ", ";
$newString .= $tok;
}
$tok = strtok(", "); //advance to the next token
}
dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET gid = '$newString' WHERE sid = '$genreresult[sid]'") or die(_FATALERROR."Query: UPDATE ".TABLEPREFIX."fanfiction_stories SET gid = '$newString' WHERE sid = '$genreresult[sid]' Error: (".mysql_errno( ).") ".mysql_error( ));
}
dbquery("DELETE FROM ".TABLEPREFIX."fanfiction_genres where gid = '$gid'") or die(_FATALERROR."Query: DELETE FROM ".TABLEPREFIX."fanfiction_genres where gid = '$gid' Error: (".mysql_errno( ).") ".mysql_error( ));
$output .= "