0) { // turn it into an object $row = mysql_fetch_object($result); } else { //echo "No results"; } // Page variables $pageType = "popular"; $bgcolour = "CCCC99"; $pathColour = $colour[$pageType]; $pageTitle = $row->name; // Page Header include ("includes/textHeader.php"); if ( $row->image1 ) { echo ""; } echo br($row->text1) . "

"; if ( $row->image2 ) { echo ""; } echo br($row->text2) . "

"; if ( $row->image3 ) { echo ""; } echo br($row->text3) . "

"; // join of projectCvLookup and projects $sql = "SELECT popularCvLookup.CID, cvs.cvName, cvs.cvDesc, cvs.cvImageThumb, cvs.cvID from popularCvLookup, cvs WHERE PID = $ID AND CID=cvs.cvID and cvDisplay = 'on';"; $related = @mysql_query($sql) or die ("Oops : " . mysql_error() ); if (mysql_num_rows($related) > 0 ) { if (mysql_num_rows($related) > 1 ) {$s = "s";} else {$s = "";}; // if there are projects, include the pageheader and give it a title $text2ndHeader = "Author$s"; include "includes/text2ndHeader.php"; echo ""; // turn result into an object called $row while($row = mysql_fetch_object($related)) { echo "\n"; if ($row->cvImageThumb) { $colspan = " colspan='3'"; echo "\n"; echo ""; } else { $colspan=""; } echo "\n"; echo "\n"; } echo "
$row->cvName
"; // grab first 200 chars of the description to use as an introduction. echo substr ( $row->cvDesc, 0 ,200); echo "... More details >\n"; echo "
"; } else { // echo "No Personnel registered for display."; } include ("includes/footer.php"); /* include of footer */ ?>