Browse staff

0) { echo "

"; echo "List of experts"; echo "

"; } else echo "No records found"; while ($i < $num) { $username = mysql_result($result,$i,"username"); $titleid = mysql_result($result,$i,"title"); $query_title = "select title from titles where titleid = '$titleid'"; $result_title = mysql_query($query_title); $row_title = mysql_fetch_array($result_title); $title = $row_title["title"]; $firstname = mysql_result($result,$i,"firstname"); $surname = mysql_result($result,$i,"lastname"); $email = mysql_result($result,$i,"email"); $campus = mysql_result($result,$i,"campus"); $faculty = mysql_result($result,$i,"faculty"); $school = mysql_result($result,$i,"school"); $research = mysql_result($result,$i,"research"); //echo $g; $i++; echo "
"; echo "
"; //echo $i; echo ". "; echo ""; echo $title; echo " "; echo $firstname; echo " "; echo $surname; echo ""; echo "
"; if($research != null) { echo "

"; $items = explode('|',$research); for($it=0; $it<=count($items); $it=$it+2){ if($items[$it]!=null) { echo "- "; echo ucwords($items[$it]); if($items[$it+1] == "yes") echo " (S)"; echo "
"; } } echo "

"; } echo "

"; echo "
"; } } if($num!=null) { $navlink=str_replace("index.php",$pagename,$self); if ($pageNum > 1) { $page = $pageNum - 1; $prev = " [Prev] "; $first = " [First Page] "; } else { $prev = ' [Prev] '; // we're on page one, don't enable 'previous' link $first = ' [First Page] '; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " [Next] "; $last = " [Last Page] "; } else { $next = ' [Next] '; // we're on the last page, don't enable 'next' link $last = ' [Last Page] '; // nor 'last page' link } // print the page navigation link echo $first . $prev . " Showing page $pageNum of $maxPage pages " . $next . $last; } mysql_close(); ?>