<% include ("forms/init_formsdb.inc"); $db = 'forms'; init_db($db); $formsearchcriterion .= "MAP ='T' order by title"; $fhits=0; $fquery ="SELECT mc,price,stock,title,dept,size,mat,ea,pk25,pk50,pk100, ENGPDF,ARBPDF,CROPDF,JPEPDF,KORPDF,KURPDF,LAOPDF,RUSPDF,SPAPDF,VIEPDF FROM formlog"; // where $formsearchcriterion"; $fresult = mysql_query($fquery); while ($row = mysql_fetch_array($fresult)) : //processing to put database fields into shape //for display $displaymc = $row["mc"]; $displayprice = $row["price"]; if ($row["stock"]=='T') {$displaymethod="Kept in stock";} else {$displaymethod="Printed on demand";} $displaytitle = $row["title"]; $displaydept = $row["dept"]; $displaysize = $row["size"]; $displaymat = $row["mat"]; if ($row["ea"]=='T') {$issuecode=1;} if ($row["pk25"]=='T') {$issuecode=2;} if ($row["pk50"]=='T') {$issuecode=3;} if ($row["pk100"]=='T') {$issuecode=4;} switch ($issuecode) { Case 1: $displayunit="Each"; break; Case 2: $displayunit="Packs of 25"; break; Case 3: $displayunit="Packs of 50"; break; Case 4: $displayunit="Pads of 100"; break; default: $displayunit="Not Specified"; break; } if ($row["ENGPDF"]=='T') {$displayengpdf="YES";} else {$displayengpdf="NO";} if ($row["ARBPDF"]=='T') {$displayarbpdf="YES";} else {$displayarbpdf="NO";} if ($row["CROPDF"]=='T') {$displaycropdf="YES";} else {$displaycropdf="NO";} if ($row["JPEPDF"]=='T') {$displayjpepdf="YES";} else {$displayjpepdf="NO";} if ($row["KORPDF"]=='T') {$displaykorpdf="YES";} else {$displaykorpdf="NO";} if ($row["KURPDF"]=='T') {$displaykurpdf="YES";} else {$displaykurpdf="NO";} if ($row["LAOPDF"]=='T') {$displaylaopdf="YES";} else {$displaylaopdf="NO";} if ($row["RUSPDF"]=='T') {$displayruspdf="YES";} else {$displayruspdf="NO";} if ($row["SPAPDF"]=='T') {$displayspapdf="YES";} else {$displayspapdf="NO";} if ($row["VIEPDF"]=='T') {$displayviepdf="YES";} else {$displayviepdf="NO";} //these fields are not selected //because they do not need to //be manipulated // $row["webmap"]; // $row["peplsoft"]; // $row["univmcommn"]; //if title is not blank (indicating a blank record) and does not being with //the string "Prescription Pad" (these are considered sensitive), then //output the record. If these checks fail, nothing is output for that record. //also exclude our own forms - Copy & Post if ($displaytitle !="" && strncmp ($displaytitle, "Prescription Pad", 16) != 0 && strncmp ($displaydept, "Copy", 4) != 0 && strncmp ($displaydept, "Copier/Fax", 10) != 0 && strncmp ($displaydept, "Post Office", 11) != 0) { include "formdisplayresult.htm"; $fhits=$fhits+1; } endwhile; if ( $fhits>0 ) { echo "
"; print( "MATCHES FOUND WAS:  $fhits" ); echo "
"; include "FMapLinksList.htm"; echo "
"; print( "Back to Home Page" ); } else { print( "SORRY—NO MATCHES FOUND.

" ); include "FMapLinksList.htm"; print( "Back to Home Page" ); echo "


"; } %>
Visit the VUMC home page.

Maps with MC numbers may be ordered from the Copy Center.
Those which say YES in the PDF row can also be downloaded here.
At bottom is a list of other web-based map resources at Vanderbilt.