Post-show traditions...

Name the places and drinks that fit these descriptions:

'; $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 to hang out in after a show:

Best drink to celebrate a show with:

Best drink to forget a show with:

 

">Login so you can add your answer to this survey. Check out the results so far below.'; } } print '

'; $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 "

Best bar(s) to hang out in after the show:

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

'; } $result = db_query($sql, $key . '.2'); if (!empty($result)) { print "

Best drink(s) to celebrate a show with:

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

'; } $result = db_query($sql, $key . '.3'); if (!empty($result)) { print "

Best drink(s) to forget a show with:

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

'; } ?>