<?php
$link=mysql_connect("localhost","root","");//链接数据库
if(!$link) ;
else ;
mysql_select_db("job", $link);
$a = "SELECT jobid,postdate FROM faces";//对数据库列表下字段进行查询
$b = "SELECT jobid,losedate FROM faces";
$c = "SELECT jobid,message FROM detail";
$d = "SELECT jobid,placedetail FROM detail";
mysql_query("SET NAmES GB2312");
$rsa = mysql_query($a, $link);
$rsb = mysql_query($b, $link);
$rsc = mysql_query($c, $link);
$rsd = mysql_query($d, $link);
if(!$rsa){die("Valid resulta!");}
if(!$rsb){die("Valid resulta!");}
if(!$rsc){die("Valid resulta!");}
if(!$rsd){die("Valid resulta!");}
mysql_close($link);
?>
<?php
echo "<table>";
echo "<tr><td>招聘信息</td><td>开始时间</td><td>截止时间</td><td>公司地址</td></tr>";
while($rowc = mysql_fetch_row($rsc))//显示调用结果
while($rowa = mysql_fetch_row($rsa))
while($rowb = mysql_fetch_row($rsb))
while($rowd = mysql_fetch_row($rsd))
echo "<tr><td>$rowc[1]</td><td>$rowa[1]</td><td>$rowb[1]</td><td>$rowd[1]</td></tr>";
echo "</table>";
?>