"; $result = mysql_query($sql , $cnx); if (mysql_num_rows($result)<1): $message="No+Record+in+the+database"; //Header("Location: error.php?error=$message"); exit; endif; while ($rs = mysql_fetch_array($result) ) { // As we need to do more queries, store the record set in local variables. $ID=$rs["ID"]; // echo "ID=" . $rs["ID"] . "
"; $Title=$rs["Title"]; $Subheading=$rs["Subheading"]; $Body=$rs["Body"]; $IssueNumber=$rs["IssueNumber"]; $Active=$rs["Active"]; $ThumbImageFlag=$rs["ThumbImageFlag"]; $MainImageFlag=$rs["MainImageFlag"]; $MediaTypeID=$rs["MediaTypeID"]; $PriorityID=$rs["PriorityID"]; $Priority=$rs["Priority"]; list ($Keyword1, $Keyword2, $Keyword3) = split (' ', $rs["Keywords"]); list ($Year, $Month, $Day) = split ('-', $rs["ArticleDate"]); $Image_Old=$rs["Image_Old"]; // this is an interim measure until images are reintegrated into the database $Document_Old=$rs["Document_Old"]; // this is an interim measure until images are reintegrated into the database // values from mediatypes table $Category=$rs["Category"]; $Filename=$rs["Filename"]; // Control fields from mediatypes table $EditTitle=$rs["EditTitle"]; $MediaTypeVisible=$rs["MediaTypeVisible"]; $PriorityTypeVisible=$rs["PriorityTypeVisible"]; $SubheadingVisible=$rs["SubheadingVisible"]; $ThumbnailVisible=$rs["ThumbnailVisible"]; $MainImageVisible=$rs["MainImageVisible"]; $DeleteRecord=$rs["DeleteRecord"]; $ManageMediaVisible=$rs["ManageMediaVisible"]; } ?> PBRS / Added Value

",$Body); echo $string ?>

"; echo "\r\n"; if ($Zoom == 1) { $zoomHTML = "
\"View"; } else { $zoomHTML = "
"; } if ($Hyperlink!="") { echo "\r\n"; } else { echo "\r\n"; } echo "\r\n"; } $rs = mysql_fetch_array($result); $DocumentID=$rs["ID"]; $DocumentFlag=$rs["DocumentFlag"]; $Hyperlink = $rs["Hyperlink"]; $Zoom = $rs["Zoom"]; $MimeType=$rs["Type"]; if ($DocumentFlag == 1) { echo "\r\n"; if ($Zoom == 1) { $zoomHTML = "
\"View"; } else { $zoomHTML = "
"; } if ($Hyperlink!="") { echo "\r\n"; } else { echo "\r\n"; } ?>
" . $zoomHTML . "" . $zoomHTML . "" . $zoomHTML . "" . $zoomHTML . "
   
0) { $rs = mysql_fetch_array($result); ?> 0) { $rs = mysql_fetch_array($result); ?>
-
-
" target="_blank">-
" target="_blank">-
"CHECKED") { ?>
 
homeinfo-basket