$fnm $lnm successfully"; } elseif (($_POST['action'] == 'Remove') && ($_POST['toremov'])) { $remvsql = "update person set curator_privilege='0' where pID='$_POST[toremov]'"; $remving = mysql_query($remvsql, $connect); #---- $getnmsql = "select name_first, name_last from person where pID='$_POST[toremov]'"; $getnm = mysql_query($getnmsql, $connect); list($fnm,$lnm) = mysql_fetch_array($getnm); $mesg = "Removed \"curator\" previliage from user $fnm $lnm successfully"; } ?>
Curator management
$mesg

\n"; } ?>

You may move ( i.e. add/ remove ) one person at a time.

Curators

\n"; while (list($pid,$fnm,$lnm) = mysql_fetch_array($dognms)) { print "
    • \n"; } ?>


    Regular users

    '1' order by name_last"; ##-COALESCE(curator_privilege,'')<>'1' covers all non-'1', including NULL and ''. $dognms=mysql_query($otherors, $connect); print "
    \n"; while (list($pid,$fnm,$lnm) = mysql_fetch_array($dognms)) { print "
    • \n"; } ?>