No job listings match your search."; /* If the number variable is greater than 0 then continue*/ ELSEIF ($number > 0) : IF (($titlesearch != "") OR ($citysearch != "") OR ($districtsearch != "") OR ($countysearch != "")) { PRINT "

Total number of job postings found: $number

"; } $i = 0; PRINT "
"; /* REPEATING LOOP OF RECORDS STARTS*/ $color = array("1"=>"ffffff","2"=>"cccccc"); $a = 0; WHILE ($i < $number): $a++; $schoolunit = mysql_result($result,$i,"schoolunit"); $county = mysql_result($result,$i,"county"); $title = mysql_result($result,$i,"title"); $postdate = mysql_result($result,$i,"DATE_FORMAT(postdate, '%c/%d/%Y')"); $recordid = mysql_result($result,$i,"recordid"); PRINT ""; PRINT ""; PRINT ""; PRINT ""; PRINT ""; IF ($a > 1){ $a = 0; } $i++; ENDWHILE; /* LOOP ENDS HERE*/ PRINT "
Date Posted Job Title School Unit
$postdate$title$schoolunit


"; ENDIF; MYSQL_CLOSE(); ?>