Minnesota Playlist readers

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 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) { ?>

Performer Writer Composer Director Choreographer Designer Production staff Producer Teacher Administrator Audience member

 

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 '

'; ?>

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) { ?>

Every day A few times a week Once a week A few times a month Occasionally

 

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 '

'; ?>