query($wpdb->prepare("UPDATE wp_quiz_question SET question=%s, explanation=%s WHERE ID=%d", $_REQUEST['content'], $_REQUEST['explanation'], $_REQUEST['question'])); $wpdb->query($wpdb->prepare("DELETE FROM wp_quiz_answer WHERE question_id=%d", $_REQUEST['question'])); showMessage('Question updated.'); } else { $wpdb->query($wpdb->prepare("INSERT INTO wp_quiz_question(quiz_id, question, explanation) VALUES(%d, %s, %s)", $_REQUEST['quiz'], $_REQUEST['content'], $_REQUEST['explanation']));//Inserting the questions showMessage('Question added.'); $_REQUEST['question'] = $wpdb->insert_id; $action='edit'; } $question_id = $_REQUEST['question']; //Yes, we need 2 different counters - the $counter will skip over empty answers - $sort_order_counter won't. $counter = 1; $sort_order_counter = 1; foreach ($_REQUEST['answer'] as $answer_text) { $correct=0; if($_REQUEST['correct_answer'] == $counter) $correct=1; if($answer_text) { $wpdb->query($wpdb->prepare("INSERT INTO wp_quiz_answer(question_id,answer,correct, sort_order) VALUES(%d, %s, %s, %d)", $question_id, $answer_text, $correct, $sort_order_counter)); $sort_order_counter++; } $counter++; } } if($_REQUEST['message'] == 'new_quiz') { showMessage('New quiz added'); } if($_REQUEST['action'] == 'delete') { $wpdb->query($wpdb->prepare("DELETE FROM wp_quiz_answer WHERE question_id=%d", $_REQUEST['question'])); $wpdb->query($wpdb->prepare("DELETE FROM wp_quiz_question WHERE ID=%d", $_REQUEST['question'])); showMessage('Question Deleted.'); } $quiz_name = stripslashes($wpdb->get_var($wpdb->prepare("SELECT name FROM wp_quiz_quiz WHERE ID=%d", $_REQUEST['quiz']))); ?>

[QUIZZIN ]

get_results("SELECT ID, question FROM `wp_quiz_question` WHERE quiz_id='$_REQUEST[quiz]'"); if (count($all_question)) { $bgcolor = ''; $class = ('alternate' == $class) ? '' : 'alternate'; $question_count = 0; foreach($all_question as $question) { $question_count++; print "\n"; ?>
#
question) ?> answer_count ?> ' class='edit'> ' class='delete' onclick="return confirm('');">