Please enter your first name.'); $errors .=reqFieldCheck($last_name, '
  • Please enter your last name.
    • '); $errors .=reqFieldCheck($email, '
  • Please enter your e-mail address.
    • '); $errors .=emailCheck($email, '
  • Please enter a valid e-mail address.
    • '); $errors .=reqFieldCheck($phone, '
  • Please enter your phone number.
    • '); $errors .=reqFieldCheck($answer, '
  • Please select an answer.
    • '); $errors .=reqFieldCheck($class, '
  • Please select your classification.
    • '); if ($errors== '') { $new_response = "INSERT INTO trivia_responses(first_name, last_name, email, phone, user_class, question_id, choice_id, response_date) VALUES('$first_name','$last_name','$email','$phone',$class,$question_id,$answer,NOW())"; $add_response = mysql_query($new_response); header('Location:http://forty.iupui.edu/trivia_success.html'); exit(); } } else { $answer = 0; $first_name = ''; $last_name = ''; $email = ''; $phone = ''; $class = 0; } $question_query = "SELECT question_id, question_text FROM trivia_questions WHERE display_date <= NOW() ORDER BY display_date DESC LIMIT 0,1"; $get_question = mysql_query($question_query); $question_array = mysql_fetch_array($get_question); $question_id = $question_array['question_id']; $question = $question_array['question_text']; $choice_query = "SELECT c.choice_id, c.choice_text FROM trivia_choices c INNER JOIN trivia_question_choices qc ON c.choice_id=qc.choice_id WHERE qc.question_id=$question_id ORDER BY c.choice_id"; $get_choice = mysql_query($choice_query); $class_query = "SELECT class_id, class_name FROM user_classes ORDER BY class_id"; $get_class = mysql_query($class_query); if ($question_id > 1) { $previous_question_id = $question_id -1; $previous_question_query = "SELECT q.question_id, q.question_text, c.choice_text FROM trivia_questions q INNER JOIN trivia_choices c ON q.answer_id=c.choice_id WHERE q.question_id=$previous_question_id"; $get_previous_question = mysql_query($previous_question_query); $previous_question_array = mysql_fetch_array($get_previous_question); $previous_question = $previous_question_array['question_text']; $previous_answer = $previous_question_array['choice_text']; } ?> Trivia : 40th Anniversary Celebration : IUPUI

    Celebrating 40 Years of Excellence!

    1969 - 2009

    Trivia

    Think you know all there is to know about IUPUI? Take a stab at this week's trivia question! Each of your correct answers will enter your name into a prize drawing. Every 12 weeks we will pick a winner. The more questions you answer correctly the better chance you have at winning! So keep playing!

    And the Third Round Trivia Winners are...

    Erin: Student Category
    Prize Package: 40th Anniversary mug and frame, IUPUI t-shirt, $10 Dining Certificate to McCormick & Schmick's Seafood Restaurant and a $25 Gift Certificate to Barnes and Noble!

    Jill: Faculty and Staff Category
    Prize Package: 40th Anniversary mug and frame, IUPUI t-shirt, $10 Lunch Certificate to McCormick & Schmick's Seafood Restaurant and 2 Dance Kaleidoscope Ticket Vouchers!

    Congratulations to our third round winners!