Same as before - no output:

>>

Warning: Cannot modify header information - headers already sent by (output started at /home/mmadent/public_html/foru/control_quiz.php:64) in /home/mmadent/public_html/foru/includes/functions.php on line 3543

hey battye

It is indeed correct (ID 10).

its the only Quiz in the DB.

and of course when I load control_quiz.php?mode=enter_answers&id=10 the page loads just fine and I am shown all the questions to enter the correct results.

Its only when I submit the answers that the SQL error occurs

thanks battye... I get no output there:

>>

Warning: Cannot modify header information - headers already sent by (output started at /home/mmadent/public_html/foru/control_quiz.php:64) in /home/mmadent/public_html/foru/includes/functions.php on line 3543

Hi battye

Yep, column exists and is populated throughout

Hi battye Im about to patch this custom version upto beta 4, but before I do thought id try and resolve an issue. Ive just run our first competition...60 or so entries, 11 questions (predictions). I closed the competition successfully. Today Ive come to enter the correct answers, and Im getting this...

OPEN quiz.php FIND around line 60 $result = $db->sql_query($sql); while( $row = $db->sql_fetchrow($result) ) REPLACE WITH $result = $db->sql_query($sql); while( $row = $db->sql_fetchrow($result) && $_POST['question' . $question_id_set[$i]] != 'cancelled' ) Then if a match is cancelled, ente...

Thanks :) So Id first edit the question so that 'Cancelled' is one of the multiple choice options for that question (maybe replaced 'Draw' with 'Cancelled')? Then re-enter the answer using ?mode=enter_answers, and select the 'cancelled' option for that question? Also, just to confirm that re-enterin...

Hi battye, I hope your weekend has been good.....thanks for the reply... One usage question on this battye.... If a match is cancelled, perhaps mid way through the week, when the comp is still open and lots of people have made their votes already, what is the correct procedure to remove that questio...

Thanks moongirl !! Cheating attempts happen because you refreshed the quiz submission page. It is to stop people from refreshing the page in order to reset the time limit. So don't ever refresh a quiz page :wink: battye....where should I be looking to relax the cheating detection. Specifically I onl...

One usage question on this battye.... If a match is cancelled, perhaps mid way through the week, when the comp is still open and lots of people have made their votes already, what is the correct procedure to remove that question from the comp (or mark it as invalid if removal is not possible), such ...

In the spirit of the site....and to remember one of the greats

Many thanks battye......Looks to be working, but in reverse: QUIZ ID: 9 QUIZ NAME: Test Event Kamara666 (correct: 0, incorrect: 3) jnrpepaseed (correct: 1, incorrect: 2) Dragonfoxy (correct: 1, incorrect: 2) subvertbeats (correct: 2, incorrect: 1) SQL Query entered Is it simple to swap the order to ...

Ahh not quite there.... The correct/incorrect ordering seems wrong: QUIZ ID: 8 QUIZ NAME: Heres my test comp Dent (correct: 1, incorrect: 2) subvertbeats (correct: 2, incorrect: 1) SQL Query entered (in the above example subvertbeats should be above Dent, with less incorrect answers). Is this workin...

It is indeed a minor thing, and with that SQL code to delete the stats for a given quiz ID I think we're set!

Ive updated the OP, and everything in Phase 1 seems to be taken care of!

Ok..... So, its all looking great. One safety feature Id like to put in is for the stats for a given comp to be removed when you change the answers (i.e. to prevent stats being recorded twice). In reality, it shouldnt happen - but human error could easily mean an incorrect result is submitted with t...