News & Notes

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 '

'; ?>

uid)); if (isset($_POST['submit'])) { $sql = "insert into {survey} (uid, q, a) values (%d, '%s', '%s')"; for ($i=1; $i<=2; $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) { ?>

Which one statement is most true for you?
I got into performing arts for the love I got into performing arts for the fame I got into performing arts for the money Theater saved me from a life of crime

How's that working out for you?
Hell yes Comes and goes Filled with regret Just confused

 

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

'; for ($i=1; $i <= 2; $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 '

'; } ?>

Choose one:

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

a lawyer a doctor a plumber a politician Joe Dowling

 

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 '

'; ?>