News & Notes

  • For the love of ...

    Editorial
    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?

    How's that working out for you?

     

    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 '

    '; } ?>
    read the story
  • I should have been ...

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

     

    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
  • 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
  • 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