= \"50000000\")"; } elseif ($cost == 2) { $query .= " $where ((cost >= \"20000000\") AND (cost <= \"50000000\"))"; } elseif ($cost == 3) { $query .= " $where ((cost >= \"10000000\") AND (cost <= \"20000000\"))"; } elseif ($cost == 4) { $query .= " $where (cost <= \"10000000\")"; } if ($where == "WHERE") { $where = "AND"; } } if ($sqfoot != "") { if ($sqfoot == 1) { $query .= " $where (sqfoot >= \"200000\")"; } elseif ($sqfoot == 2) { $query .= " $where ((sqfoot >= \"150000\") AND (sqfoot <= \"200000\"))"; } elseif ($sqfoot == 3) { $query .= " $where ((sqfoot >= \"100000\") AND (sqfoot <= \"150000\"))"; } elseif ($sqfoot == 4) { $query .= " $where ((sqfoot >= \"50000\") AND (sqfoot <= \"100000\"))"; } elseif ($sqfoot == 5) { $query .= " $where ((sqfoot >= \"20000\") AND (sqfoot <= \"50000\"))"; } elseif ($sqfoot == 6) { $query .= " $where (sqfoot <= \"20000\")"; } if ($where == "WHERE") { $where = "AND"; } } if ($order == "buildingname") { $query .= " ORDER BY buildingname, chronname"; } elseif ($order == "institution") { $query .= " ORDER BY chronname, buildingname"; } elseif ($order == "state") { $query .= " ORDER BY state, chronname, buildingname"; } elseif ($order == "type") { $query .= " ORDER BY type, chronname, buildingname"; } elseif ($order == "architect") { $query .= " ORDER BY Arch1, chronname, buildingname"; } elseif ($order == "opened") { $query .= " ORDER BY dateopen DESC, chronname, buildingname"; } elseif ($order == "sqfoot") { $query .= " ORDER BY sqfoot DESC, chronname, buildingname"; } elseif ($order == "cost") { $query .= " ORDER BY cost DESC, chronname, buildingname"; } else { $query .= " ORDER BY chronname, buildingname"; } ###################### # Get the count here # ###################### $mysql_count_result = mysql_query($query, $dbLink); #print "$query"; $total = mysql_num_rows($mysql_count_result); ############################################################### # Limit the number of returned entries, 50 is the # to return # ############################################################### if (($offset == "") || ($offset < 0)) { $offset = 0; } if ($showall != "yes") { # print "$offset $limit
prev-$previous, next-$next
\n"; if ($previous == "previous") { $offset = $offset - $limit; } elseif ($next == "next") { $offset = $offset + $limit; } if ($offset < 1) { $offset = "0"; } # print "$offset $limit
prev-$previous, next-$next
\n"; $query .= " LIMIT $offset, $limit"; } ?>

The Chronicle of Higher Education
Research


\n"; print " \n"; print " \n"; print " \n"; print " \n"; if ($row->Arch2 != "") { print " \n"; } else { print " \n"; } print " \n"; if($row->sqfoot!=0) { print " \n"; } else { print " \n"; } print " \n"; print " \n"; } if ($first == 1) { ?> \n"; print "\n"; print "\n"; } ?>

About these data