Minnesota Playlist readers
Articles by Author
-
For the love of ...
Editorialuid)); 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) { ?>
'; 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 ''; } ?>read the story -
Thankfully, MinnesotaPlaylist.com provides ...
EditorialCheck all that apply:
'; $sql = "select count(*) from (select distinct uid from {survey} where q = '%s') as users"; $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] = 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 = 'like'; $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<=6; $i++) { if (!empty($_POST[$i])) { $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) { ?>read the story -
I should have been ...
EditorialChoose one:
'; $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 ''; ?>
"; $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) { ?>read the story -
Letters to the editor: June 2009
EditorialGary Peterson, whose resume includes a stretch as the Executive Director of the James Sewell Ballet, clues us...read the story -
Letters to the editor: February 2009
EditorialOn "Reviewing the media" issue
The coverage of media relations on the site this month is both timely and accurate...read the story -
Big ol' virtual suggestion box 2009
EditorialHere are a series of propositions we solicited from you. Where there’s a will, there’s a way.
What we’d like
...read the story -
Letters to the editor: January 2009
EditorialOn “City Pages cuts theater coverage in half” and Quinton Skinner’s “Live Wire”
At the tail end of what has...
read the story -
Letters to the editor: November 2008
EditorialWe encourage thoughtful comments, ideas, disagreements, and criticism. Write us. Here are some of the messages we’ve been sent so...
read the story