function GetJobPost($recordid) { GLOBAL $schoolunit, $city, $county, $title, $qualifications; GLOBAL $description, $salaryrange, $deadline, $startdate; GLOBAL $additionalinformation, $name, $contacttitle, $district; GLOBAL $address, $contactcity, $state; GLOBAL $zip; GLOBAL $phoneareacode; GLOBAL $phonethreedigits; GLOBAL $phonefourdigits; GLOBAL $faxareacode; GLOBAL $faxthreedigits; GLOBAL $faxfourdigits; GLOBAL $email; GLOBAL $link; GLOBAL $districtsize; GLOBAL $schoolsize; GLOBAL $communitydescription; GLOBAL $postedby; $userstable = "jobs_tbl"; $dbName = "servings_db01"; /* make connection to database */ MYSQL_CONNECT(208.110.132.7,lawschool,current) OR DIE("Unable to connect to database"); @mysql_select_db( "$dbName") or die( "Unable to select database"); /*Establish the SQL query*/ $query = "SELECT * from $userstable WHERE recordid = '$recordid'"; $result = MYSQL_QUERY($query); /*Determine how many records match the query*/ $number = MYSQL_NUMROWS($result); $schoolunit = mysql_result($result,$i,"schoolunit"); $city = mysql_result($result,$i,"city"); $state = mysql_result($result,$i,"state"); $county = mysql_result($result,$i,"county"); $title = mysql_result($result,$i,"title"); $qualifications = mysql_result($result,$i,"qualifications"); $description = mysql_result($result,$i,"description"); $salaryrange = mysql_result($result,$i,"salaryrange"); $postdate = mysql_result($result,$i,"postdate"); $deadline = mysql_result($result,$i,"deadline"); $startdate = mysql_result($result,$i,"startdate"); $additionalinformation = mysql_result($result,$i,"additionalinformation"); $name = mysql_result($result,$i,"name"); $contacttitle = mysql_result($result,$i,"contacttitle"); $district = mysql_result($result,$i,"district"); $address = mysql_result($result,$i,"address"); $contactcity = mysql_result($result,$i,"contactcity"); $state = mysql_result($result,$i,"state"); $zip = mysql_result($result,$i,"zip"); $phoneareacode = mysql_result($result,$i,"phoneareacode"); $phonethreedigits = mysql_result($result,$i,"phonethreedigits"); $phonefourdigits = mysql_result($result,$i,"phonefourdigits"); $faxareacode = mysql_result($result,$i,"faxareacode"); $faxthreedigits = mysql_result($result,$i,"faxthreedigits"); $faxfourdigits = mysql_result($result,$i,"faxfourdigits"); $email = mysql_result($result,$i,"email"); $link = mysql_result($result,$i,"link"); $districtsize = mysql_result($result,$i,"districtsize"); $schoolsize = mysql_result($result,$i,"schoolsize"); $communitydescription = mysql_result($result,$i,"communitydescription"); $postedby = mysql_result($result,$i,"postedby"); MYSQL_CLOSE(); } GetJobPost($recordid); ?>
| Edit Job Posting | |||
| City/State: | " SIZE="25"> | ||
| County: | |||
| Position Title: | " SIZE="15"> | ||
| Qualifications: | $qualifications = StripSlashes($qualifications); ?> | ||
| Position Description: | $description = StripSlashes($description); ?> | ||
| Salary Range: | " SIZE="25"> | ||
| Application Deadline: | "> | ||
| Start Date: | " SIZE="25"> | ||
| Additional Information: | $additionalinformation = StripSlashes($additionalinformation); ?> | ||
|
Submit Applications to: |
|||
| Name: | " SIZE="25"> | ||
| Title: | " SIZE="25"> | ||
| School District: | " SIZE="25"> | ||
| Address: | " SIZE="30"> | ||
| City/State/Zip: | " SIZE="15"> " SIZE="5"> | ||
| Telephone: | (" SIZE="3">) " SIZE="3">- " SIZE="4"> | ||
| Fax: | (" SIZE="3">) " SIZE="3">- " SIZE="4"> | ||
| E-mail: | " SIZE="20"> | ||
|
School Information: |
|||
| Website: | " SIZE="20"> | ||
| District Size: | " SIZE="6"> | ||
| School Size/Description: | $schoolsize = StripSlashes($schoolsize); ?>|||
| Community Description: | $communitydescription = StripSlashes($communitydescription); ?>|||
| Username: | |||
| recordid: | |||
|
|||