$value ) { $$key = trim( $value ); } if($CLR == "" || $CLR == "Clear Form") { $CRIT1=""; $VALUE1=""; $PROF="";} mysql_connect("","wwwuser","designwww!"); mysql_select_db("JOBS"); if($PROF == "%") { $C1a = "SELECTED";} if($PROF == "1") { $C1 = "SELECTED";} if($PROF == "2") { $C2 = "SELECTED";} if($PROF == "3") { $C3 = "SELECTED";} if($PROF == "4") { $C4 = "SELECTED";} if($PROF == "5") { $C5 = "SELECTED";} if($PROF == "6") { $C6 = "SELECTED";} if($PROF == "7") { $C7 = "SELECTED";} if($CRIT1 == "JOB.TITLE") {$D1 = "SELECTED"; } if($CRIT1 == "COMPANY.CITY") {$D2 = "SELECTED"; } if($CRIT1 == "COMPANY.STATE") {$D3 = "SELECTED"; } if($CRIT1 == "COMPANY.NAME") {$D4 = "SELECTED"; } if($CRIT1 == "%") {$D5 = "SELECTED"; } /* GET TODAY'S DATE...*/ $today = time(); $wk = $today - 2419200; $day = getdate($wk); if($ALL == "YES") {$wk = 1;} echo"

Search our database of posted positions since $day[month] $day[mday], $day[year] Choose a professional category --Select a Profession-- All Professions Art and Design Architecture Community and Regional Planning Graphic Design Interior Design Landscape Architecture Miscellaneous Search Criteria --Choose a field-- Job Title City State (abbreviation) Company Name Any Position (find all) = Show listings prior to $day[mon]/$day[mday]/$day[year]

"; if($JID != "") { $query="select COMPANY.*,JOB.* from COMPANY,JOB where COMPANY.CID=JOB.CID and JOB.JID=$JID group by JOB.TITLE"; } else { if($CLR == "Start Over") {exit;} if($VALUE1 == "" && $FIRST == "") { exit; } if($CRIT1 != "%") { $query="select COMPANY.*,JOB.* from COMPANY,JOB,JCAT where COMPANY.CID=JOB.CID AND JCAT.JID=JOB.JID and JCAT.CATEGORY like '$PROF' and $CRIT1 like '%$VALUE1%' and JOB.DPOST > $wk group by JOB.TITLE,COMPANY.NAME order by JOB.DPOST DESC"; } else { $query="select COMPANY.*,JOB.* from COMPANY,JOB,JCAT where COMPANY.CID=JOB.CID AND JCAT.JID=JOB.JID and JCAT.CATEGORY like '$PROF' AND JOB.DPOST > $wk group by JOB.TITLE,COMPANY.NAME order by JOB.DPOST DESC"; } } if($PROF == "no") { echo"Please choose a profession first

"; exit; } if($CRIT1 == "no") { echo"Please choose a Criteria Field first
"; exit; } if($B == "1") { $b="Art and Design";} if($B == "2") { $b="Architecture";} if($B == "3") { $b="Community and Regional Planning";} if($B == "4") { $b="Graphic Design";} if($B == "5") { $b="Interior Design";} if($B == "6") { $b="Landscape Architecture";} if($B == "7") { $b="Miscellaneous";} $res = mysql_query($query); $nr = mysql_num_rows($res); if($nr < 1) { echo"
Sorry no job listings match your criteria"; exit;} $index = 0; echo"There were $nr hits for your query

"; while($index < $nr) { $row=mysql_fetch_array($res); $d2=date("m/d/y", $row[DPOST]); echo"
1. $row[TITLE] $row[NAME] posted-$d2"; $index = $index + 1; } echo"

"; mysql_data_seek($res, 0); $index=0; $color=color; while ($index < $nr) { $row = mysql_fetch_row($res); echo("

$row[16]"); //if($row[3] != "") { echo"-$row[3], $row[4]";} echo("	Back to top
$row[1] $row[17]
Information"); if($row[24] != "") { if($row[24] > 0) { $q2="select * from CONTACT where KID=$row[24]"; $qres=mysql_query($q2); $qrow=mysql_fetch_array($qres); if($qrow[CONTACT]) { echo" Contact: $qrow[NAME]"; } if($qrow[ADDRESS] != "") { echo" Address: $qrow[ADDRESS], $qrow[CITY], $qrow[STATE] $qrow[ZIP]"; } if($qrow[PHONE] != "") { echo" Phone: $qrow[PHONE]";} if ($qrow[FAX] != "") { echo(" Fax: $qrow[FAX]");} if ($qrow[EMAIL] != "") { echo(" email address $qrow[EMAIL]");} } } /*THIS WAS REMOVED 10-20-00 if ($row[18] < 0) { $d1="open";} else { $d1=date("l, F d, Y", $row[18]);} */ $d2=date("m/d/y", $row[19]); echo(" Posted: $d2 Posted in Design Career News as $row[21] Also listed under: "); $q2="select * from JCAT where JID=$row[15]"; $res2=mysql_query($q2); $nr2=mysql_num_rows($res2); $i2=0; while($i2<$nr2) { $r2=mysql_fetch_row($res2); if($r2[1] == "1") { $r="Art and Design";} else { if($r2[1] == "2") { $r="Architecture";} else { if($r2[1] == "3") { $r="Community and Regional Planning";} else { if($r2[1] == "4") { $r="Graphic Design";} else { if($r2[1] == "5") { $r="Interior Design";} else { if($r2[1] == "6") { $r="Landscape Architecture";} else { if($r2[1] == "7") { $r="Miscellaneous";} }}}}}} if($i2 == "0") {$list=$r;} else { $list="$list, $r";} $i2 = $i2 + 1; } echo"$list "; $index = $index + 1; } ?>