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.
<%
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 "";
}
%>
