News & Notes

Check all the theater-related websites that apply:

'; $key = 'also'; $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<=12; $i++) { if (!empty($_POST[$i])) { if (($i == 12) && (!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) { ?>

 callboard.org
 fringefamous.tumblr.com
 twincities.com/stage
 startribune.com/entertainment/onstage
 springboardforthearts.org
 mnartists.org
 Southern Theater Dance newsletter
 tctheaterconnection.com
 examiner.com
 minnpost.com/arts
 tcdailyplanet.net/arts
 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 '

'; } }?>

Be honest about your feelings about our Talent List (relax, it's anonymous):

"; $key = 'talent'; $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) { ?>

Too expensive Won't get me work Will get me work, but not the kind I want I'm shy Too difficult to enter all my resume information What's a Talent Profile? I have a Talent Profile

 

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 '

'; ?>

Provide the name of a member of the performing arts community whose opinions or ideas you want to read in MinnesotaPlaylist:

'; $key = 'hear'; $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'])) { if (!empty($_POST['name'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST['name']); } 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 a, count(*) as count_a from {survey} where q = '%s' group by a order by count_a desc"; $result = db_query($sql, $key); if (!empty($result)) { print "

Responses so far:

"; while ($data = db_fetch_object($result)) { print '
• ' . $data->a . ' (' . $data->count_a . ')
'; } print '

'; } ?>

Choose the month/issue where you felt MinnesotaPlaylist.com did the best job:

'; $key = 'issue'; $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) { ?>

October: The purpose of performance November: Behind the curtain December: Know your audience January: The state of the state February: Reviewing the media March: Tis the season May: What's new June: On the road July: Stories August: Fringe points of view

 

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 '

'; ?>

Which Artistic Director would make the best astronaut? Choose one:

'; $key = 'astronaut'; $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) { ?>

Joe Dowling Dominique Serrand Michelle Hensley Lou Bellamy Stuart Pimsler Wendy Knox

 

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 '

'; ?>

Name the Minnesota theaters that fit these descriptions:

'; $key1 = 'bond_cast'; $key2 = 'bond_artist'; $key3 = 'bond_audience'; $sql = "select count(a) from {survey} where q like '%s' and uid=%d"; $count = db_result(db_query($sql, 'bond%', $user->uid)); if (isset($_POST['submit'])) { if (!empty($_POST['bond1'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key1, $_POST['bond1']); } if (!empty($_POST['bond2'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key2, $_POST['bond2']); } if (!empty($_POST['bond3'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; db_query($sql, $user->uid, $key3, $_POST['bond3']); } print 'Thanks for taking our survey. Your answer has been included in the results below.'; } else { if ($user->uid) { if ($count == 0) { ?>

Best dressing room to bond with the cast:

Best backstage for secret love affairs:

Best place for onstage nude scenes:

 

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 {survey} where q = '%s' group by a order by count_a desc"; $result = db_query($sql, $key1); if (!empty($result)) { print "

Results for best dressing room to bond with the cast:

"; while ($data = db_fetch_object($result)) { print '
• ' . $data->a . ' (' . $data->count_a . ')
'; } print '

'; } $result = db_query($sql, $key2); if (!empty($result)) { print "

Results for best backstage for secret love affairs:

"; while ($data = db_fetch_object($result)) { print '
• ' . $data->a . ' (' . $data->count_a . ')
'; } print '

'; } $result = db_query($sql, $key3); if (!empty($result)) { print "

Results for best place for onstage nude scenes:

"; while ($data = db_fetch_object($result)) { print '
• ' . $data->a . ' (' . $data->count_a . ')
'; } print '

'; } ?>

Choose your astrological sign. If you don't know, guess:

"; $key = 'sign'; $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) { ?>

Aries Taurus Gemini Cancer Leo Virgo Libra Scorpio Sagittarius Capricorn Aquarius Pisces

 

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 '

'; ?>

Choose which birth order describes you:

"; $key = 'birth'; $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) { ?>

oldest youngest middle only child

 

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 '

'; ?>

You know what to do.

"; $key = 'lightning1'; $sql = "select count(a) from {survey} where q like '%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')"; 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) { ?>

Dogs or cats?
dogs cats

Puppets or clowns?
puppets clowns

Planes, trains, or automobiles?
planes trains automobiles

 

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 {survey} 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 {survey} 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 '

'; } ?>

Fire away.

"; $key = 'lightning2'; $sql = "select count(a) from {survey} where q like '%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')"; 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) { ?>

Tequila or Jagermeister?
Tequila Jagermeister

John Hughes or Judd Apatow?
John Hughes Judd Apatow

William Shakespeare or Anton Chekhov?
William Shakespeare Anton Chekhov

 

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 {survey} 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 {survey} 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 '

'; } ?>

You know what to do.

"; $key = 'lightning3'; $sql = "select count(a) from {survey} where q like '%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')"; 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) { ?>

Opera or tuba?
opera tuba

Classical dance or contact improv?
classical dance contact improv

Walker, Southern, or Ritz?
Walker Southern Ritz

 

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 {survey} 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 {survey} 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 '

'; } ?>

Pick one play you wish was not in the Bard's canon (Relax, it's anonymous):

"; $key = 'shakespeare'; $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) { ?>

King Lear Hamlet Pericles Troilus and Cressida The Merry Wives of Windsor Merchant of Venice Taming of the Shrew

 

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 '

'; ?>