Problemos su viktorina

Sveiki pas mane yra viktorina su mysql ir ajax. Todel viktorinos faile yra labai daug update gal kas turi koki kita buda kaip jus viktorina pasileidziat arba ka galima padaryti ar sumazini ir kaip jog nebutu tiek daug update va kaip atrodo:

$status_check = mysql_num_rows(mysql_query("SELECT * FROM viktorina WHERE status='0'"));

if ($status_check > 0) {

$sql=mysql_query("SELECT * FROM viktorina WHERE status='0'");

while ($row=mysql_fetch_array($sql)) {

$answer_length=strlen($row['answer']);

$question_id=$row['id'];

$sql2=mysql_query("UPDATE viktorina SET kiek='$answer_length' WHERE id=$question_id");}}

$sql3=mysql_query("UPDATE viktorina SET answered='' WHERE answered!='' AND status='0'");

$check=mysql_num_rows(mysql_query("SELECT * FROM viktorina WHERE status!='0' AND status!='5'"));

if ($check<1) {

$query=("SELECT * FROM viktorina WHERE status='0' ORDER BY RAND() LIMIT 1");

$result=mysql_query($query) or die("error");

while ($row=mysql_fetch_array($result)) {

$quiz_id=$row[id];}

$query=mysql_query("UPDATE viktorina SET status='1' WHERE id='$quiz_id'");

}

$status2_check = mysql_num_rows(mysql_query("SELECT * FROM viktorina WHERE status='2'"));

if ($status2_check>0) {

$sql=mysql_query("SELECT * FROM viktorina WHERE status='2'");

while ($row=mysql_fetch_array($sql)) {

$answer=$row['answer'];

$answered=$row['answered'];

$answered111=$row['answered'];

$timeout=$row['timeout'];}

$next=$timeout-$time2;

$sql=mysql_query("UPDATE viktorina SET status='0' WHERE status='1'") or die("ERROR");

$question="Kitas klausimas bus uz: <b>$next s.</b>";

$answer="Atsakymas buvo: <b>$answer</b>";

if ($answered == "") {$answered="<b>Niekas :(</b>";}

$answered="Atsake: <b>$answered</b><br/>";

if ($timeout<=($time2)) {

$query=("SELECT * FROM viktorina WHERE status='0' ORDER BY RAND() LIMIT 1");

$result=mysql_query($query) or die("error");

while ($row=mysql_fetch_array($result)) {

$quiz_id=$row[id];}

$query=mysql_query("UPDATE viktorina SET status='1' WHERE id='$quiz_id'");

$sql=mysql_query("UPDATE viktorina SET status='0' WHERE status='2'");

$question="Ruosiamas kitas klausimas";

$answer="...";

}

}

$status1_check = mysql_num_rows(mysql_query("SELECT * FROM viktorina WHERE status='1'"));

if ($status1_check > 0) {

$sql=mysql_query("SELECT * FROM viktorina WHERE status='1'");

while ($row=mysql_fetch_array($sql)) {

$timeout=$row['timeout'];

$hide=$row['kiek'];

$answer_length=strlen($row['answer']);

}

if ($timeout<=$time2) {

$timeout=$time2+10;

$hide=$hide-1;}

$sql=mysql_query("UPDATE viktorina SET timeout='$timeout' WHERE status='1'") or die("ERROR");

$sql=mysql_query("UPDATE viktorina SET kiek='$hide' WHERE status='1'") or die("ERROR");

$sql=mysql_query("SELECT * FROM viktorina WHERE status='1' and kiek>0");

while ($row=mysql_fetch_array($sql)) {

$question=$row['question'];

$answer=$row['answer'];

$timeout=$row['timeout'];

$hide=$row['kiek'];

}

if ($hide=="1") {

$timeout=$time2+39;

$sql=mysql_query("UPDATE viktorina SET timeout='$timeout' WHERE status='1'") or die("ERROR");

$sql=mysql_query("UPDATE viktorina SET status='2' WHERE status='1'") or die("ERROR");}

$answer_length=strlen($answer);

$answer=substr($answer, 0, ($answer_length-$hide));

$hiding="**************************************************************************************";

$hide=substr($hiding, 0, $hide);

}

echo "<span style=\"color:#000000\">$question</span><br/>";

echo "<span style=\"color:#000000\">$answer$hide $answered</span>";

Padaryk gal buttoną kokį, kad tada tikrintų, nes dabar kaip supratau tikrina iškart įvedus atsakymą taip?

Na matai su ajax tikrina kas minute todel valgo daug cpu