include_once('../fix_mysql.inc.php'); header( "Pragma: no-cache" ); header( "Cache-Control: no-cache" ); header( "Expires: Sat, 01 Jan 2000 00:00:00 GMT" ); $server = "a2nlmysql39plsk.secureserver.net"; $username = "db2yc3"; $password = "DBpsw2yc3"; $database = "db2yc3"; $today = date("Y"); $lastyear = $today -1; $yearago = $lastyear.'-01-01'; $today = $today.' '; if (isset($_GET['year'])) { $today = $_GET['year']; } if (!mysql_connect($server, $username, $password)) { $r_string = '&errorcode=1&'; } elseif (!mysql_select_db($database)) { $r_string = '&errorcode=2&'; } else { $region=$_GET['region']; $result = ("SELECT * FROM `industrial` ORDER BY `company` "); if (!mysql_query ($result)) { $msg = mysql_error(); $r_string = '&errorcode=3&msg='.$msg; } else { // pass back vars of corresponding user $result = mysql_query("SELECT * FROM `college` WHERE `year`=$today ORDER BY `college` "); $num_rows = mysql_num_rows($result); while($row = mysql_fetch_array($result)){ $r_string .= '
|