Procurement and Business Services
FAS To FRS Lookup ";
if ($fas <> '')
{
$query1 = 'SELECT * FROM datadate where tablename="' . $tablename . '"';
$result1 = MYSQL_QUERY($query1);
$validdate = mysql_result($result1, 0, "lastimported");
print "(Data valid as of $validdate)";
}
print "\n";
print " \n";
print '";
print " ";
if ($fas <> '')
{
#$query = "SELECT * FROM $table1 where fasno > '0' order by fasno";
$query = 'SELECT * FROM ' . $tablename . ' where fasno = "' . $fas . '"';
$result = MYSQL_QUERY($query);
/* How many of these users are there? */
$number = MYSQL_NUMROWS($result);
/* Print these results to the screen in a nice format */
$i = 0;
IF ($number == 0)
{
PRINT "
Cannot find a corresponding FRS Number for FAS Number $fas