If only MinnesotaPlaylist ...

Choose no more than THREE features you wish the website had:

'; $key = 'want'; $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<=9; $i++) { if (!empty($_POST[$i])) { if (($i == 9) && (!empty($_POST['other']))) { $sql = "insert into {survey} (uid, q, a, other) values (%d, '%s', '%s', '%s')"; db_query($sql, $user->uid, $key, $_POST[$i], $_POST['other']); } else { $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) { ?>

 comprehensive performance calendar
 audience reviews
 vendor resource guide (graphic design, headshot photography, make-up artists, etc.)
 daily blogs
 professional criticism
 video previews
 more arts news coverage
 more diverse voices
 other
If other, briefly describe: 

 

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 '

'; $sql = "select other, count(*) as count_other from {survey} where q='%s' and other <> '' group by other order by count_other desc"; $result = db_query($sql, $key); if (!empty($result)) { print "

'Other' responses:

"; while ($data = db_fetch_object($result)) { print '
• ' . $data->other . ' (' . $data->count_other . ')
'; } print '

'; } } ?>