News & Notes

  • At the Iveys. . .

    News
    In case you haven't heard, the Ivey awards went off at the State Theatre last night. (The Sage awards are...
    read the story
  • I am a ...

    Editorial
    Choose the ONE occupation you most identify with:


    '; $key = 'occupation'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['a']); print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(a) from {survey} where q='%s'"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = $data->qty; $n=$n+1; } $values = implode(',', $qty); $labels = implode('|', $word); print '

    '; ?>
    read the story
  • I visit MinnesotaPlaylist.com ...

    Editorial
    How frequently:


    '; if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['a']); print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if ($count == 0) { ?>

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(a) from {survey} where q='%s'"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = $data->qty; $n=$n+1; } $values = implode(',', $qty); $labels = implode('|', $word); print '

    '; ?>
    read the story
  • As an artist, I earn ...

    Editorial
    Please include only your arts-related income:


    '; $key = 'earn'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['a']); print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(a) from {survey} where q='%s'"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = $data->qty; $n=$n+1; } $values = implode(',', $qty); $labels = implode('|', $word); print '

    '; ?>
    read the story
  • My total household income is ...

    Editorial
    Include both arts-related and non-arts income:


    "; $key = 'household'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['a']); print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(a) from {survey} where q='%s'"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = $data->qty; $n=$n+1; } $values = implode(',', $qty); $labels = implode('|', $word); print '

    '; ?>
    read the story
  • I live in ...

    Editorial
    Choose where you live:


    '; $key = 'live'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['a']); print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(a) from {survey} where q='%s'"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = $data->qty; $n=$n+1; } $values = implode(',', $qty); $labels = implode('|', $word); print '

    '; ?>
    read the story
  • I am ...

    Editorial
    Select your age (Relax, it's anonymous):


    "; $key = 'age'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['a']); print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(a) from {survey} where q='%s'"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = $data->qty; $n=$n+1; } $values = implode(',', $qty); $labels = implode('|', $word); print '

    '; ?>
    read the story
  • Thankfully, MinnesotaPlaylist.com provides ...

    Editorial
    Check all that apply:


    '; $key = 'like'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { for ($i=1; $i<=6; $i++) { if (!empty($_POST[$i])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i]); } } print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     audition notices
     training opportunities
     performance calendar
     talent profiles
     in-depth articles
     news and notes

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(*) from (select distinct uid from {survey} where q = '%s') as users"; $count = db_result(db_query($sql, $key)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = 100 * $data->qty/$count; $n=$n+1; } $values = implode(',', $qty); foreach($word as $i=>$val) { $labels = $labels . 't ' . $val . ',166665,0,' . $i . ',12|'; } $labels = substr($labels,0,strlen($labels)-1); $max_val = (intval((max($qty)/.7)/5)+1)*5; $interval = round($max_val/5); print '

    '; ?>
    read the story
  • If only MinnesotaPlaylist ...

    Editorial
    Choose no more than THREE features you wish the website had:


    '; $key = 'want'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { for ($i=1; $i<=9; $i++) { if (!empty($_POST[$i])) { if (($i == 9) && (!empty($_POST['other']))) { $sql = "insert into {survey} (uid, q, a, other) values (%d, '%s', '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i], $_POST['other']); } else { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i]); } } } print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     comprehensive performance calendar
     audience reviews
     vendor resource guide (graphic design, headshot photography, make-up artists, etc.)
     daily blogs
     professional criticism
     video previews
     more arts news coverage
     more diverse voices
     other
    If other, briefly describe: 

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(*) from (select distinct uid from {survey} where q = '%s') as users"; $count = db_result(db_query($sql, $key)); if ($count>0) { $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = 100 * $data->qty/$count; $n=$n+1; } $values = implode(',', $qty); foreach($word as $i=>$val) { $labels = $labels . 't ' . $val . ',166665,0,' . $i . ',12|'; } $labels = substr($labels,0,strlen($labels)-1); $max_val = (intval((max($qty)/.7)/5)+1)*5; $interval = round($max_val/5); print '

    '; $sql = "select other, count(*) as count_other from {survey} where q='%s' and other <> '' group by other order by count_other desc"; $result = db_query($sql, $key); if (!empty($result)) { print "

    'Other' responses:

      "; while ($data = db_fetch_object($result)) { print '
    • ' . $data->other . ' (' . $data->count_other . ')
    • '; } print '
    '; } } ?>
    read the story
  • I need to know more about ...

    Editorial
    Choose no more than FIVE subjects you want MInnesotaPlaylist to cover in upcoming issues:


    '; $key = 'subjects'; $sql = "select count(a) from {survey} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit'])) { for ($i=1; $i<=20; $i++) { if (!empty($_POST[$i])) { if (($i == 20) && (!empty($_POST['other']))) { $sql = "insert into {survey} (uid, q, a, other) values (%d, '%s', '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i], $_POST['other']); } else { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i]); } } } print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

     politics
     survival
     theater in education
     training
     academia
     film/multimedia
     non-traditional performance settings (site-specific, street theater, etc.)
     non-Western theater
     non-profit management
     marketing
     fundraising
     new ideas
     music in theater
     design
     performance art
     unions
     poetry and spoken word
     backstage and technical stuff
     ensemble theater
     other
    If other, briefly describe: 

     

    Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

    '; $sql = "select count(*) from (select distinct uid from {survey} where q = '%s') as users"; $count = db_result(db_query($sql, $key)); if ($count>0) { $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey} where q='%s' group by word"; $result = db_query($sql, $key); while($data = db_fetch_object($result)) { $word[$n] = $data->word . ' (' . 100 * (number_format($data->qty / $count, 2)) . '%)'; $qty[$n] = 100 * $data->qty/$count; $n=$n+1; } $values = implode(',', $qty); foreach($word as $i=>$val) { $labels = $labels . 't ' . $val . ',166665,0,' . $i . ',12|'; } $labels = substr($labels,0,strlen($labels)-1); $max_val = (intval((max($qty)/.7)/5)+1)*5; $interval = round($max_val/5); print '

    '; $sql = "select other, count(*) as count_other from {survey} where q='%s' and other <> '' group by other order by count_other desc"; $result = db_query($sql, $key); if (!empty($result)) { print "

    'Other' responses:

      "; while ($data = db_fetch_object($result)) { print '
    • ' . $data->other . ' (' . $data->count_other . ')
    • '; } print '
    '; } }?>
    read the story