Post-show traditions...
';
$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(s) to hang out in after the show:
- ";
while ($data = db_fetch_object($result)) {
print '
- ' . $data->a . ' (' . $data->count_a . ') '; } print '
Best drink(s) to celebrate a show with:
- ";
while ($data = db_fetch_object($result)) {
print '
- ' . $data->a . ' (' . $data->count_a . ') '; } print '
Best drink(s) to forget a show with:
- ";
while ($data = db_fetch_object($result)) {
print '
- ' . $data->a . ' (' . $data->count_a . ') '; } print '