0) { echo ''; $cols=16; while($row = mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++){ if($i==0)echo '
ID: '.$row[0].' | Title: '.$row[2].'
File Type: '.$row[5].'
Subtopic: '.$row[9].'
Topic: '.$row[10].' |
Reference: '.$row[11].'
Minor Subject: '.$row[8].'
Subject: '.$row[12].'
'; } echo "\n"; } } //echo ''; } function RESULT2($link,$query){ $result =mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { echo ''; echo ''; $cols=16; while($row =mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++){ if($i==0)echo ''; } echo "\n"; } } echo '

No: '.$row[0].' Title: '.$row[1].' Type: '.$row[4].' Transcript: Yes Audio: Yes Topic: '.$row[7].' Reference: '.$row[8].' Subject: '.$row[9].'

';} function RESULT($link,$query){ $result =mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { echo ''; echo ''; echo ''; $cols=16; while($row =mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++){ if($i==0)echo ''; } echo "\n"; } } echo '

No	Title	ID	5. FileType	9. Subtopic	10. Topic	11. Reference:	8. Minor Subject	12. Subject
'.$row[1].'	'.$row[2].'	'.$row[0].'	'.$row[5].'	'.$row[9].'	'.$row[10].'	'.$row[11].'	'.$row[8].'	'.$row[12].'

';} //-------------------- function RESULT_TOTAL($link,$query,$sid){ global $sid; $nrows=1; $result = mysqli_query($link,$query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { $cols=16; while($row = mysqli_fetch_row($result)) { $ROW[$nrows]=$nrows++; // echo 'number of rows: '.$nrows; for($i = 0; $i<= $cols; $i++){ if($i==0){ $ROW[$nrows]=$row[0]; } } echo "\n"; } } $Nrows=$nrows; $Nrows=$Nrows-1; $rownumber=rand(1,$Nrows); //echo 'rownumber: '.$rownumber.'| |'.$ROW[$rownumber]; $sid=$ROW[$rownumber]; } //----------- function RESMCQ($link, $query){ $result =mysqli_query($link, $query) or die ("Error in query: $query. ".mysqli_error()); if (mysqli_num_rows($result) > 0) { echo ''; echo ''; echo ''; $cols=16; while($row =mysqli_fetch_row($result)) { for($i = 0; $i<= $cols; $i++){ if($i==0)echo ''; } echo "\n"; } } echo '

No	Problem	Ans	Ans (a)	Ans(b)	Ans (c)	Ans (d)	Solution	Topic
'.$row[0].'	'.$row[1].'	('.$row[2].')	(a). '.$row[3].'	(b). '.$row[4].'	(c). '.$row[5].'	(d). '.$row[6].'	'.$row[7].'	'.$row[8].'

';} ?>