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].'
ok
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 '
NoTitleID5. FileType9. Subtopic10. Topic11. Reference: 8. Minor Subject12. 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 '
NoProblemAnsAns (a)Ans(b)Ans (c)Ans (d)SolutionTopic
'.$row[0].''.$row[1].'('.$row[2].')(a). '.$row[3].'(b). '.$row[4].'(c). '.$row[5].'(d). '.$row[6].''.$row[7].''.$row[8].'
';} ?> '; echo '
'; //echo ''; echo '
Subjects'; for ($j=1;$j<=3;$j++){ for ($k=1;$k<=8;$k++){ $i=8*($j-1)+$k; $sub_title=$SUB_TITLE[$i]; //echo '
'; echo ''; } echo '
'; } echo ''; /* for ($i=7;$i<=11;$i++){ echo ''; } echo ''; echo ''; for ($j=2;$j<=4;$j++){ echo ''; } echo ''; echo ''; echo ''; echo ''; echo ''; echo '
'; //echo ''; //echo ''; //echo ''; //echo ''; //echo ''; //echo '
'; echo 'Chemical Engineering - Afternoon'; echo '
'; */ ?>