News & Notes

  • My friends/family think I'm ...

    Editorial
    Choose the one you most often feel:


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

     

    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 '

    '; ?>
    read the story
  • I make art to ...

    Editorial
    Choose the one you most identify with:


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

     

    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 '

    '; ?>
    read the story
  • The Minnesota performing arts are ...

    Editorial
    Choose FIVE (Relax, just go with it):


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

     rainbow
     razor
     bouncy
     stringy
     orange
     phlegmatic
     ladder
     anti
     over
     under
     around
     falsetto
     stripped
     glass
     rubber
     purple
     round
     loose
     smart
     triangle

     

    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 '

    '; } ?>
    read the story
  • Dear Guthrie, please do this.

    News
    Every playwright I know who has thought about it -- and a good number of directors I know too --...
    read the story
  • Love at first sight

    Editorial
    11:14 AM. August 12, 2009. By now, I expect, you've heard about the 2009 Fringe Festival numbers -- more than...
    read the story
  • Anna stalks Quinton Skinner

    Editorial
    10:39pm. August 11, 2009. My mother told me yesterday that she had been reading all of my blogs about the...
    read the story