| There was a problem with the query syntax |
";
exit;
}
if (mysql_num_rows($query)==0) {
echo "";
exit;
}
print "\n";
print "\n";
print "\n";
print "| \n";?>
|
\n";
print "| \n";?>
\n";
print " | \n";
print "\n";
print "| \"$keyword\"查询结果（共 $total 条） |
|---|
\n";
print "\n";
print "| 公司名称 | \n";
print "空缺职位 | \n";
print "数量 | \n";
print " \n";
$fcount = 1;
if ($count) {
$fcount = $count + 1;
$i = 0;
while ($rsCat = mysql_fetch_array($query)) {
$i ++;
if ($i >= $count) {
break;
}
}
}
$i = 0;
while($rsCat = mysql_fetch_array($query)) {
$sql1="select * from $bookname where username='$rsCat[10]'";
$query1=mysql_query($sql1, $conn);
$rsCat1 = mysql_fetch_array($query1);
print "\n";
print "| $rsCat1[2] | \n";
print "$rsCat[0] | \n";
print "$rsCat[2] | \n";
print " \n";
$count ++;
$i++;
if ($i >= 20) {
break;
}
}
print "| （$fcount - $count 条） | \n";
if ($count < $total) {
print "| 下面还有 | \n";
}
print " |
\n";
}elseif($job_lb){
//职位查询
$sql="select * from $zpname where job_lb='$job_lb'";
$query=mysql_query($sql, $conn);
$total=mysql_num_rows($query);
if (!(mysql_errno()==0)) {
echo "| There was a problem with the query syntax |
";
exit;
}
if (mysql_num_rows($query)==0) {
echo "";
exit;
}
print "\n";
print "\n";
print "\n";
print "| \n";?>
|
\n";
print "| \n";?>
\n";
print " | \n";
print "\n";
print "| \"$job_lb\"查询结果（共 $total 条） |
|---|
\n";
print "\n";
print "| 公司名称 | \n";
print "空缺职位 | \n";
print "数量 | \n";
print " \n";
$fcount = 1;
if ($count) {
$fcount = $count + 1;
$i = 0;
while ($rsCat = mysql_fetch_array($query)) {
$i ++;
if ($i >= $count) {
break;
}
}
}
$i = 0;
while($rsCat = mysql_fetch_array($query)) {
$sql1="select * from $bookname where username='$rsCat[10]'";
$query1=mysql_query($sql1, $conn);
$rsCat1 = mysql_fetch_array($query1);
print "\n";
print "| $rsCat1[2] | \n";
print "$rsCat[0] | \n";
print "$rsCat[2] | \n";
print " \n";
$count ++;
$i++;
if ($i >= 20) {
break;
}
}
print "| （$fcount - $count 条） | \n";
if ($count < $total) {
print "| 下面还有 | \n";
}
print " |
\n";
}elseif($username&$post){
//详细信息
$sql="select * from $zpname where username='$username' and post='$post'";
$query=mysql_query($sql, $conn);
$query=quoted_printable_decode($query);
$sql1="select * from $bookname where username='$username'";
$query1=mysql_query($sql1, $conn);
$query1=quoted_printable_decode($query1);
if (!(mysql_errno()==0)) {
echo "| There was a problem with the query syntax |
";
exit;
}
if (mysql_num_rows($query)==0) {
echo "| No items were found matching the criteria |
";
exit;
}
while($rsCat = mysql_fetch_array($query) and $rsCat1 = mysql_fetch_array($query1)) {
print "\n";
print "\n";
print "\n";
print "\n";
print "| 职位信息详细情况\n";
print " |
\n";
print "\n";
print "| 单位名称 | \n";
print "$rsCat1[2] | \n";
print "详细地址 | \n";
print "$rsCat1[3] | \n";
print "
\n";
print "\n";
print "| 邮政编码 | \n";
print "$rsCat1[4] | \n";
print "联系人 | \n";
print "$rsCat1[5] | \n";
print "
\n";
print "\n";
print "| 电话 | \n";
print "$rsCat1[6] | \n";
print "传真 | \n";
print "$rsCat1[7] | \n";
print "
\n";
print "\n";
print "| 电子邮件 | \n";
print "$rsCat1[8] | \n";
print "网址 | \n";
print "$rsCat1[9] | \n";
print "
\n";
print "\n";
print "| 职位名称 | \n";
print "$rsCat[0] | \n";
print "职位类别 | \n";
print "$rsCat[1] | \n";
print "
\n";
print "\n";
print "| 招聘人数 | \n";
print "$rsCat[2] | \n";
print "性别要求 | \n";
print "$rsCat[3] | \n";
print "
\n";
print "\n";
print "| 最低学历 | \n";
print "$rsCat[4] | \n";
print "职称 | \n";
print "$rsCat[5] | \n";
print "
\n";
print "\n";
print "| 年龄要求 | \n";
print "$rsCat[6]-$rsCat[7] | \n";
print "工作经验 | \n";
print "$rsCat[8] | \n";
print "
\n";
print "\n";
print "| 单位简介 | \n";
print "
\n";
print "\n";
print "| $rsCat1[10] | \n";
print "
\n";
print "\n";
print "| 职位描述 | \n";
print "
\n";
print "\n";
print "| $rsCat[9] | \n";
print "
\n";
print "
\n";
}
}else{
//显示主页
?>