"; // start the table print ""; print ""; print ""; print ""; print "
"; // the first cell will have the logo and the search button print ""; // her we will have a search button print "

Search for a person

"; print "
"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "
"; print ""; print "
"; print ""; print "
"; print ""; print "
"; print "
"; print "

"; include ("colab2.html"); print "
"; print ""; print ""; // add a spacer print ""; // the second cell will have the menu print ""; // the third cell will have the photograph and the alphabet print ""; print ""; print ""; // add a spacer print ""; print ""; print ""; print "
"; print "

"; print "A"; print "B"; print "C"; print "D"; print "E"; print "F"; print "G"; print "H"; print "I"; print "J"; print "K"; print "L"; print "M
"; print "N"; print "O"; print "P"; print "Q"; print "R"; print "S"; print "T"; print "U"; print "V"; print "W"; print "X"; print "Y"; print "Z

"; print "
"; $arch_list = mysql_query( "SELECT `id`,`altid`,`surname`,`name`,`engineer`,`other` FROM `tblarch` WHERE `type` = 1 AND `surname` LIKE '$sortby' ORDER BY `surname`"); print ""; print ""; while ($arch_line = mysql_fetch_array ( $arch_list )) { // print "Archid is $arch_line[id]"; if ($arch_line[id] != 2065) { if ($arch_line[id] != 5186) { if ($arch_line[altid]) { $archid = $arch_line[altid]; } else { $archid = $arch_line[id]; } if ($arch_line[engineer] == 0) { $desc = "Architect"; } else if ($arch_line[engineer] == 1) { $desc = "Engineer"; } else if ($arch_line[engineer] == 2) { $desc = "Contractor"; } else if ($arch_line[engineer] == 3) { $desc = "Quantity Surveyor"; } else if ($arch_line[engineer] == 4) { $desc = "Landscape Architect"; } else if ($arch_line[engineer] == 5) { $desc = "Interior"; } else if ($arch_line[engineer] == 6) { $desc = "Structural Engineer"; } else if ($arch_line[engineer] == 7) { $desc = "Master Craftsman"; } else if ($arch_line[engineer] == 8) { $desc = "Land Surveyor"; } else if ($arch_line[engineer] == 9) { $desc = "Military Engineer"; } else if ($arch_line[engineer] == 10) { $desc = "Artist"; } else if ($arch_line[engineer] == 11) { $desc = "Photographer"; } else if ($arch_line[engineer] == 12) { $desc = $arch_line[other]; } else if ($arch_line[engineer] == 13) { $desc = "Author"; } else if ($arch_line[engineer] == 14) { $desc = "Archeologist"; } else { $desc = ""; } print ""; } } } print "

$arch_line[surname], $arch_line[name] - $desc
"; print "
"; print "
"; print "

"; // close the database connection mysql_close( $link ); ?>