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 RESULT3($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
SubTopic: '.$row[7].'
Topic: '.$row[8].'
Reference: '.$row[9].'
Subject: '.$row[10].'

';} 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].'
SubTopic: '.$row[7].'
Topic: '.$row[8].'
Reference: '.$row[9].'
Subject: '.$row[10].'

';} function RESULT4($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	Handout	Figure	File Type	Lecture	Audio	SubTopic	Topic	Reference	Subject
'.$row[0].'	'.$row[1].'	Yes	Yes	'.$row[4].'	Yes	Yes	'.$row[7].'	'.$row[8].'	'.$row[9].'	'.$row[10].'

';} 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	Type	SubTopic	Topic	Reference:	Minor Subject	Subject
'.$row[1].'	'.$row[2].'	'.$row[0].'	'.$row[5].'	'.$row[9].'	'.$row[10].'	'.$row[11].'	'.$row[8].'	'.$row[12].'

';} function RES_CONNECT($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	Topic	Subject
'.$row[0].'	'.$row[1].'	'.$row[7].'	'.$row[9].'

';} function RESMCQ($link,$query){ global $correct_answer, $solution,$sid; $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 ''; $correct_answer=$row[4]; $solution=$row[9]; $sid=$row[0]; } echo "\n"; } } echo '

ID	'.$row[0].'
Problem No.	'.$row[1].'
Equation	.'.$row[3].'
Statement	('.$row[2].')
Ans. (a)	(a). '.$row[5].'
Ans. (b)	(b). '.$row[6].'
Ans. (c)	(c). '.$row[7].'
Ans. (d)	(d). '.$row[8].'
Subtopic	'.$row[10].'
Topic	'.$row[11].'
Subject	'.$row[12].'

';} //-------------------- function RES_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; echo 'Number of Records: '.$Nrows; $Nrows=$Nrows-1; $rownumber=rand(1,$Nrows); //echo 'Record No. '.$rownumber.'| Record ID: |'.$ROW[$rownumber]; $sid=$ROW[$rownumber]; echo 'Record ID: |'.$sid; } //-------------------- function RESULT6($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){ $next_sr_id=$row[0]+1; echo ''; echo ''; } echo "\n"; } } echo '

|'.$row[0].'||'.$row[1].'||'.$row[2].'||'.$row[12].'||'.$row[8].'||'.$row[10].'||'.$row[9].':|'.$row[5].'|'.$row[11].'|Next:|

';}} ?>

'; echo '

'; echo '

'; echo ''; //http://www.reviewpe.com/penotes/f_file_type.php?%20&%20file_type=Handout%20&%20subject=Mass/Energy%20Balances%20and%20Thermodynamics for ($i=1;$i<=6;$i++){ $file_type='Presentation'; $sub_title=$SUB_TITLE[$i]; //echo ''; //echo ''; echo ''; //echo ''; } echo ''; ?>

'.$sub_title.'