<?
include('../db.php');
if (!$_SESSION['isAdmin']) {
    die('Error !');
}

$id = (int) $_GET['id'];
$thisniche = array();
$sresult = dbQuery("SELECT * FROM content_niches WHERE content = '$id'",false);
foreach($sresult as $srow) { 
    $thisniche[] = $srow['niche'];
}
?>

<select name="niche[]" multiple="multiple" class="full-width">
    <? $presult = dbQuery("SELECT * FROM niches ORDER BY name ASC",false); ?>
    <? foreach($presult as $srow) { ?>
        <option<? echo in_array($srow['record_num'], $thisniche) ? ' selected' : ''; ?> value="<? echo $srow['record_num']; ?>"><? echo $srow['name']; ?></option>
    <? } ?>
</select>