"; //echo "-" . $TOWN . "-"; $errors = false; $typeDesc = ""; if (strlen($TYPE) > 0) { // jdr 2011-05-26 // $con = mysql_connect("db1627.perfora.net","dbo255878133","FqNmYH53"); // mysql_select_db("db255878133", $con); // jdr 2011-05-26 $typeSQL = "select JOBTYPE_DESC from nhc_jobtypes " . "where JOBTYPE_CD = '" . $TYPE . "'"; //echo "-" . $typeSQL . "-"; $result = mysql_query($typeSQL); if ($row = @mysql_fetch_array($result)) { $typeDesc = $row['JOBTYPE_DESC']; } } $sortStatmenet = ""; $month = date("m"); if ($month == "1" || $month == "5" || $month == "9") { $sortStatement = " ORDER BY CONTRACTOR_ID"; } else if ($month == "2" || $month == "6" || $month == "10") { $sortStatement = " ORDER BY COMPANY_NAME ASC"; } else if ($month == "3" || $month == "7" || $month == "11") { $sortStatement = " ORDER BY COMPANY_NAME DESC"; } else { $sortStatement = " ORDER BY TOWN"; } ?>
