Parse Error

[GnaUnited]

I have a segment of code here, it is supposed to list some things from a mySQL database but it will only list the first one, I am missing a bracket somewhere but I dont know where to put it.

function nwcmusic() {
    global $prefix, $dbi, $multilingual, $bgcolor2;
    include ("header.php");
    GraphicAdmin();
    OpenTable();
    echo "<center><font class=\"title\"><b>NWC Music Admin</b></font></center>";
    CloseTable();
    $handle=opendir('modules/NWC_Music');
    while ($file = readdir($handle)) {

            $modlist .= "$file ";

    }

closedir($handle);
$modlist = explode(" ", $modlist);
sort($modlist);
for ($i=0; $i < sizeof($modlist); $i++) {
     if($modlist[$i] != "") {
         $result = sql_query("select mid from ".$prefix."_nwcmusic where title='$modlist[$i]'", $dbi);
        list ($mid) = sql_fetch_row($result, $dbi);
        if ($mid == "") {
            sql_query("insert into ".$prefix."_nwcmusic values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);
        }
    }
}
$result = sql_query("select title from ".$prefix."_nwcmusic", $dbi);
while (list($title) = sql_Fetch_row($result, $dbi)) {
$a = 0;
$handle=opendir('modules/NWC_Music');
while ($file = readdir($handle)) {
if ($file == $title) {
$a = 1;
}
if ($file =='.') {
$a = 2;
}
if ($file =='..') {
$a = 3;
}
}
closedir($handle);
if ($a == 0) {
sql_query("delete from ".$prefix."_nwcmusic where title='$title'", $dbi);
}
if ($a == 2) {
sql_query("delete from ".$prefix."_nwcmusic where title='.'", $dbi);
}
if ($a == 3) {
sql_query("delete from ".$prefix."_nwcmusic where title='.'", $dbi);
}
if ($a == 2) {
sql_query("delete from ".$prefix."_nwcmusic where title='..'", $dbi);
}
if ($a == 3) {
sql_query("delete from ".$prefix."_nwcmusic where title='..'", $dbi);
}

echo "<br>";}

OpenTable();
echo "<br><center><font class=\"option\">"
    ."<table border=\"1\" align=\"center\"><tr><td align=\"center\" bgcolor=\"$bgcolor2\">"
    ."<b>"._TITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._CUSTOMTITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._STATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>Menu Status</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
$result = sql_query("select mid, title, custom_title, active, inmenu from ".$prefix."_nwcmusic order by title ASC", $dbi);
while(list($mid, $title, $custom_title, $active, $inmenu) = sql_fetch_row($result, $dbi)) {
    if ($custom_title == "") {
        $custom_title = ereg_replace("_"," ",$title);
        sql_query("update ".$prefix."_nwcmusic set custom_title='$custom_title' where mid='$mid'", $dbi);
    }
    if ($active == 1) {
        $active = _ACTIVE;
        $change = _DEACTIVATE;
        $act = 0;
    } else {
        $active = "<i>"._INACTIVE."</i>";
        $change = _ACTIVATE;
        $act = 1;
    }
     if ($inmenu == 1) {
        $menu = "Active";
        $menuchange = "Delete From Block";
        $acte = 0;
    } else {
        $menu = "Inactive";
        $menuchange = "Put In Block";
        $acte = 1;
    }
    if ($custom_title == "") {
        $custom_title = ereg_replace("_", " ", $title);
    }

  echo "<tr><td $background align=\"center\"> $title</td><td align=\"center\" $background>$custom_title</td><td align=\"center\" $background>$active</td><td align=\"center\" $background>$menu</td><td align=\"center\" $background>[ <a href=\"admin.php?op=nwcmusic_edit&mid=1\">"._EDIT."</a>  <a href=\"admin.php?op=nwcmusic_status&mid=$mid&active=$act\">$change</a>  <a href=\"admin.php?op=nwcmusic_menu&mid=$mid&menu=$acte\">$menuchange</a>]</td></tr></table>";

CloseTable();
include ("footer.php");
}



function nwcmusic_status($mid, $active) {

global $prefix, $dbi;

sql_query("update ".$prefix."_nwcmusic set active='$active' where mid='$mid'", $dbi);

Header("Location: admin.php?op=nwcmusic");

}

[sarahk]

have a look at this:

<?php
function nwcmusic() {
    global $prefix, $dbi, $multilingual, $bgcolor2;
    include ("header.php");
    GraphicAdmin();
    OpenTable();
    echo "<center><font class=\"title\"><b>NWC Music Admin</b></font></center>";
    CloseTable();
    $handle=opendir('modules/NWC_Music');
    while ($file = readdir($handle)) {

            $modlist .= "$file ";

    }

closedir($handle);
$modlist = explode(" ", $modlist);
sort($modlist);
for ($i=0; $i < sizeof($modlist); $i++) {
     if($modlist[$i] != "") {
         $result = sql_query("select mid from ".$prefix."_nwcmusic where title='$modlist[$i]'", $dbi);
        list ($mid) = sql_fetch_row($result, $dbi);
        if ($mid == "") {
            sql_query("insert into ".$prefix."_nwcmusic values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);
        }
    }
}
$result = sql_query("select title from ".$prefix."_nwcmusic", $dbi);
while (list($title) = sql_Fetch_row($result, $dbi)) {
$a = 0;
$handle=opendir('modules/NWC_Music');
while ($file = readdir($handle)) {
if ($file == $title) {
$a = 1;
}
elseif ($file =='.') {
$a = 2;
}
elseif ($file =='..') {
$a = 3;
}
}//while ($file = readdir($handle))
//SK: I think this is where you should close the first while
}//while (list($title) = sql_Fetch_row($result, $dbi))
closedir($handle);
//SK: these could be rationlised further
if ($a == 0) {
sql_query("delete from ".$prefix."_nwcmusic where title='$title'", $dbi);
}
elseif ($a == 2) {
sql_query("delete from ".$prefix."_nwcmusic where title='.'", $dbi);
}
elseif ($a == 3) {
sql_query("delete from ".$prefix."_nwcmusic where title='.'", $dbi);
}
elseif ($a == 2) {
sql_query("delete from ".$prefix."_nwcmusic where title='..'", $dbi);
}
elseif ($a == 3) {
sql_query("delete from ".$prefix."_nwcmusic where title='..'", $dbi);
}

echo "<br>";}

OpenTable();
echo "<br><center><font class=\"option\">"
    ."<table border=\"1\" align=\"center\"><tr><td align=\"center\" bgcolor=\"$bgcolor2\">"
    ."<b>"._TITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._CUSTOMTITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._STATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>Menu Status</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
$result = sql_query("select mid, title, custom_title, active, inmenu from ".$prefix."_nwcmusic order by title ASC", $dbi);
while(list($mid, $title, $custom_title, $active, $inmenu) = sql_fetch_row($result, $dbi)) 
{
    if ($custom_title == "") {
        $custom_title = ereg_replace("_"," ",$title);
        sql_query("update ".$prefix."_nwcmusic set custom_title='$custom_title' where mid='$mid'", $dbi);
    }
    if ($active == 1) {
        $active = _ACTIVE;
        $change = _DEACTIVATE;
        $act = 0;
    } else {
        $active = "<i>"._INACTIVE."</i>";
        $change = _ACTIVATE;
        $act = 1;
    }
     if ($inmenu == 1) {
        $menu = "Active";
        $menuchange = "Delete From Block";
        $acte = 0;
    } else {
        $menu = "Inactive";
        $menuchange = "Put In Block";
        $acte = 1;
    }
    if ($custom_title == "") {
        $custom_title = ereg_replace("_", " ", $title);
    }
//SK: seemed to not be closing this while either
}//while(list($mid, $title, $custom_title, $active, $inmenu)
  echo "<tr><td $background align=\"center\"> $title</td><td align=\"center\" $background>$custom_title</td><td align=\"center\" $background>$active</td><td align=\"center\" $background>$menu</td><td align=\"center\" $background>[ <a href=\"admin.php?op=nwcmusic_edit&mid=1\">"._EDIT."</a>  <a href=\"admin.php?op=nwcmusic_status&mid=$mid&active=$act\">$change</a>  <a href=\"admin.php?op=nwcmusic_menu&mid=$mid&menu=$acte\">$menuchange</a>]</td></tr></table>";

CloseTable();
include ("footer.php");
}//nwcmusic



function nwcmusic_status($mid, $active) {

global $prefix, $dbi;

sql_query("update ".$prefix."_nwcmusic set active='$active' where mid='$mid'", $dbi);

Header("Location: admin.php?op=nwcmusic");

}//nwcmusic_status
?>