Minnesota Playlist readers

Articles by Author

  • I visit MinnesotaPlaylist.com...

    Editorial
    How frequently:


    "; $key = 'visit'; $nid = '9065'; $sql = "select count(a) from {survey10} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit']) && ($_POST['flag_id']==$nid)) { $sql = "insert into {survey10} (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 {survey10} 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 {survey10} 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 provides...

    Editorial
    Check all that apply:


    '; $key = 'like'; $nid = '9066'; $sql = "select count(a) from {survey10} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit']) && ($_POST['flag_id']==$nid)) { for ($i=1; $i<=13; $i++) { if (!empty($_POST[$i])) { if (($i == 13) && (!empty($_POST['other']))) { $sql = "insert into {survey10} (uid, q, a, other) values (%d, '%s', '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i], $_POST['other']); } else { $sql = "insert into {survey10} (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) { ?>

     audience reviews
     audition notices
     blogs
     business profiles
     company profiles
     free volunteer and 'free stuff' notices
     in-depth articles
     links to critic reviews
     performance calendar
     talent profiles
     training opportunities
     tweets
     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 {survey10} 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 {survey10} 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 {survey10} 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
  • The Minnesota performing arts are...

    Editorial
    Choose FIVE (Relax, just go with it):


    '; $key = 'minnesota'; $nid = '9067'; $sql = "select count(a) from {survey10} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit']) && ($_POST['flag_id']==$nid)) { for ($i=1; $i<=20; $i++) { if (!empty($_POST[$i])) { $sql = "insert into {survey10} (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) { ?>

     anti
     around
     bouncy
     falsetto
     glass
     ladder
     loose
     orange
     over
     phlegmatic
     purple
     rainbow
     razor
     round
     rubber
     smart
     stringy
     stripped
     triangle
     under

     

    ">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 {survey10} 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 {survey10} 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
  • Really, the Minnesota performing arts are...

    Editorial
    Choose the THREE most accurate adjectives to describe Minnesota's performing arts:


    "; $nid='9068'; $key = 'really'; $sql = "select count(a) from {survey10} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit']) && ($_POST['flag_id']==$nid)) { for ($i=1; $i<=21; $i++) { if (!empty($_POST[$i])) { $sql = "insert into {survey10} (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) { ?>

     adventurous
     amateur
     amazing
     conservative
     decentralized
     diverse
     dumb
     experimental
     fair
     grassroots
     hierarchical
     inspirational
     lucky
     mediocre
     realistic
     professional
     risky
     smart
     unjust
     whiney
     white

     

    ">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 {survey10} 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 {survey10} 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
  • Post-show traditions...

    Editorial
    Name the places and drinks that fit these descriptions:


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

    Best bar to hang out in after a show:

    Best drink to celebrate a show with:

    Best drink to forget a show with:

     

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

    '; $sql = "select a, count(*) as count_a from {survey10} where q = '%s' group by a order by count_a desc"; $result = db_query($sql, $key . '.1'); if (!empty($result)) { print "

    Best bar(s) to hang out in after the show:

      "; while ($data = db_fetch_object($result)) { print '
    • ' . $data->a . ' (' . $data->count_a . ')
    • '; } print '
    '; } $result = db_query($sql, $key . '.2'); if (!empty($result)) { print "

    Best drink(s) to celebrate a show with:

      "; while ($data = db_fetch_object($result)) { print '
    • ' . $data->a . ' (' . $data->count_a . ')
    • '; } print '
    '; } $result = db_query($sql, $key . '.3'); if (!empty($result)) { print "

    Best drink(s) to forget a show with:

      "; while ($data = db_fetch_object($result)) { print '
    • ' . $data->a . ' (' . $data->count_a . ')
    • '; } print '
    '; } ?>
    read the story
  • In the future...

    Editorial
    Express your feelings on these issues:


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

    Audience tweeting on twitter during a show:

    Season ticket holders:

    Actors' equity:

     

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

    '; for ($i=1; $i <= 3; $i++) { $sql = "select count(a) from {survey10} where q='%s'"; $count = db_result(db_query($sql, $key . '.' . $i)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey10} where q='%s' group by word"; $result = db_query($sql, $key . '.' . $i); 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
  • Lightning round #1

    Editorial
    Fire away.


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

    Williams or Miller

    Mamet or Shepard

    Pinter or Beckett or [obtuse, meaningful, long silence]

     

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

    '; for ($i=1; $i <= 3; $i++) { $sql = "select count(a) from {survey10} where q='%s'"; $count = db_result(db_query($sql, $key . '.' . $i)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey10} where q='%s' group by word"; $result = db_query($sql, $key . '.' . $i); 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
  • If only they had dramaturgs during the Renaissance...

    Editorial
    Which great Shakespeare play has the most contrived plot points?


    "; $key = 'dramaturg'; $nid = '9075'; $sql = "select count(a) from {survey10} where q='%s' and uid=%d"; $count = db_result(db_query($sql, $key, $user->uid)); if (isset($_POST['submit']) && ($_POST['flag_id']==$nid)) { $sql = "insert into {survey10} (uid, q, a) values (%d, '%s', '%s')"; if (!empty($_POST['other'])) { db_query($sql, $user->uid, $key, $_POST['other']); } else { if (!empty($_POST['a'])) { 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) { ?>


    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(a) from {survey10} 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 {survey10} 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
  • Lightning round #2

    Editorial
    Because.


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

    Modern dance or ballet?

    Oscars or Iveys?

    Vikings, Packers, Bears, or Lions?

     

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

    '; for ($i=1; $i <= 3; $i++) { $sql = "select count(a) from {survey10} where q='%s'"; $count = db_result(db_query($sql, $key . '.' . $i)); $n=0; $word = array(); $qty = array(); $sql = "select a as word, count(uid) as qty from {survey10} where q='%s' group by word"; $result = db_query($sql, $key . '.' . $i); 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