Minnesota Playlist readers
Articles by Author
-
I visit MinnesotaPlaylist.com...
EditorialHow frequently:
'; $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 ''; ?>
"; $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) { ?>read the story -
Thankfully, MinnesotaPlaylist provides...
EditorialCheck all that apply:
'; $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 "
'; $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) { ?>'Other' responses:
- ";
while ($data = db_fetch_object($result)) {
print '
- ' . $data->other . ' (' . $data->count_other . ') '; } print '
read the story -
The Minnesota performing arts are...
EditorialChoose FIVE (Relax, just go with it):
'; $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 ''; } ?>
'; $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) { ?>read the story -
Really, the Minnesota performing arts are...
EditorialChoose the THREE most accurate adjectives to describe Minnesota's performing arts:
'; $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 ''; } ?>
"; $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) { ?>read the story -
Post-show traditions...
EditorialName the places and drinks that fit these descriptions:
'; $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 "
'; $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(s) to hang out in after the show:
- ";
while ($data = db_fetch_object($result)) {
print '
- ' . $data->a . ' (' . $data->count_a . ') '; } print '
Best drink(s) to celebrate a show with:
- ";
while ($data = db_fetch_object($result)) {
print '
- ' . $data->a . ' (' . $data->count_a . ') '; } 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...
EditorialExpress your feelings on these issues:
'; 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 ''; } ?>
"; $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) { ?>read the story -
Lightning round #1
EditorialFire away.
'; 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 ''; } ?>
"; $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) { ?>read the story -
If only they had dramaturgs during the Renaissance...
EditorialWhich great Shakespeare play has the most contrived plot points?
'; $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 ''; ?>
"; $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) { ?>read the story -
Lightning round #2
EditorialBecause.
'; 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 ''; } ?>
"; $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) { ?>read the story