|
| ";
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" |
| $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; } ?> | |