站长论坛
标题:
MySQL 资料库函式库=>mysql_data_seek()函数
[打印本页]
作者:
tznktg
时间:
2007-9-21 20:38
标题:
MySQL 资料库函式库=>mysql_data_seek()函数
MySQL 资料库函式库
mysql_data_seek
移动内部传回指标。
语法: int mysql_data_seek(int result_identifier, int row_number);
传回值: 整数
函式种类: 资料库功能
内容说明
本函式可移动内部传回的列指标到指定的 row_number 去。之后若使用 mysql_fetch_row() 可以传回新列的值。成功传回 true、失败则传回 false。
作者:
tznktg
时间:
2007-9-21 20:38
<?php
require"include/Config.php";
require"public/function.php";
require"include/seek_array.php";
require"include/seek_array3.php";
require"public/Timefunction.php";
$Bem_id=$_GET[id];
$infoid=$_GET[infoid];
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META content="Copyright 2004-2010 <? echo EENGLISHNAME;?>" name=author>
<title><? echo $ewooo_name?></title>
<link href="css_js/15hr.css" rel="stylesheet" type="text/css">
<style type="text/css">
td {font-family: "宋体";font-size: 12px;color: #000000;}
a:link {color: #000000;text-decoration: none;}
a:visited {color: #000000;text-decoration: none;}
a:hover {color: #000000;text-decoration: underline;}
a:active {color: #000000;text-decoration: none;}
ul{margin-left:20px;list-style-position:outside;list-style-type:disc;margin-bottom:0px; padding-left: 6}
li{line-height:23px;list-style-position: outside;list-style-type: disc;}
.style2 {
font-size: 12px;
color: #000000;
}
.style3 {color: #a0410a; font-size: 14px;}
.style5 {color: #000000}
.style11 {
color: #993300;
font-weight: bold;
font-size: 14px;
}
.style12 {font-size: 12px}
</style>
</head>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<body>
<?php include("include/top_1.php"); ?>
<table width="766" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="164" valign="top" bgcolor="#F7F7F7">
<?php include("$htmlurl".NUMERALADD.'_pos6.html'); ?></td>
<td valign="top" width="1" background="images/15hr_school_bg_xian.gif"></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/show_h.gif">
<tr>
<td colspan='2' height='12px'></td>
</tr>
<tr>
<td width="33%" style="padding-left:24px"><img src="images/welcometo.gif" width="149" height="43">
<?
$strdo2="select * from $job_zpinfo where user_id='$Bem_id' and zpyesno='1' order by DeptID,Register_date desc";
$result2=mysql_query($strdo2,$myconn);
$row=mysql_fetch_array($result2);
$num=mysql_num_rows($result2);
?>
</td>
<td width="67%" style="font-size:15px;color:#3333CC;font-weight:bold"><? echo $row['CompanyName']?> </td>
</tr>
</table>
<br>
<table cellspacing=0 cellpadding=0 width="100%" border="0">
<tbody>
<tr>
<td width=147 height=21></td>
<td width=21 rowspan=2><img src="Aimages/15hr_person_yleft.gif" width="21" height="22"></td>
<td align=middle width=78 background="images/15hr_company_ybg.gif" rowspan=2>
<p style="margin-top: 5px"><strong><a href="Info_invite_show.php?id=<? echo"$Bem_id";?>">公司简介</a></strong></p></td>
<td rowspan=2><img src="Aimages/15hr_person_middle.gif" width="28" height="22"></td>
<td width=80 rowspan=2 align=middle background="images/15hr_company_wbg.gif">
<p style="margin-top: 5px"><a href="Info_invite_show_3.php?id=<? echo"$Bem_id";?>">所有职位</a></p></td>
<td rowspan=2><img src="Aimages/15hr_person_wright.gif" width="24" height="22"></td>
<td width=180></td>
<td rowspan="2"></td>
<td width=50 height="21"></td>
<!--<td width=70></td>-->
</tr>
<tr>
<td height=1 bgcolor=#ddddda></td>
<td height=1 bgcolor=#ddddda></td>
<td height=1 bgcolor=#ddddda></td>
</tr>
</tbody>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="145" height="800" valign="top" bgcolor="#FBFBFB" style="padding-top:8px;padding-bottom:8px;"><table width="134" border="0" align="center" cellpadding="0" cellspacing="0">
<?
//$strdo="select zpinfo_id,PosName,DeptID from $job_zpinfo where user_id='$Bem_id' and zpyesno='1' order by DeptID,Register_date desc";
//$result=mysql_query($strdo,$myconn);
$DeptID_ids='1w_15hr.com';
mysql_data_seek($result2,0);
while($row_2=mysql_fetch_array($result2))
{
?>
<? if($DeptID_ids!=$row_2[DeptID]) {echo "<tr><td colspan=\"2\" class=\"font-14red\"> "."$row_2[DeptID]";if(!$row_2[DeptID]) echo"全部招聘岗位"; echo"</td></tr>";$DeptID_ids=$row_2[DeptID];}?>
<tr>
<td width="14%" height="28" class="font-title">?</td>
<td width="86%"><a href="Info_invite_show_2.php?infoid=<? echo $row_2['zpinfo_id'];?>&id=<? echo"$Bem_id";?>"><? echo $row_2['PosName'];?></a></td>
</tr>
<? }?>
</table></td>
<td width="449" valign="top" style="padding-left:15px;padding-top:8px;padding-bottom:8px">
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width='20px' valign='top' style=''> <strong><font color='#990000'>注：</font></strong></td>
<td>如果您对以下职位感兴趣，请直接在该职位下进行“<font color="#990000"><strong>申请该职位</strong></font>(申请面试)”、“<font color="#990000"><strong>收藏该职位</strong></font>”、“<font color="#990000"><strong>推荐给好友</strong></font>”等操作。</td>
</tr>
<tr>
<td height="4"></td>
</tr>
</table>
<?
if($num)
mysql_data_seek($result2,0);while($row=mysql_fetch_array($result2))
{?><table width='99%' border='0' cellspacing='2' cellpadding='0'><? echo"<form name=\"form"."$row[zpinfo_id]"."\" method=\"post\" action=\"Seek_join_in.php?user_id="."$row[zpinfo_id]"."\">";?>
<tr>
<td height='25' bgcolor='#f6f6f6'><div id='posidb_1079745'>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><span class="font-title">招聘职位：<? echo $row['PosName'];?><b></b></span><b> </b></td>
<td><B>
<input name="imageField2" type="image" src="images/15hr_sqms.gif" alt="申请面试" border="0">
</B></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height='25' style='padding-top:5px;padding-bottom:3px'>
<?
$strsql="select zpvip from $job_bem where Bem_id='$Bem_id' limit 0,1";
$result=mysql_query($strsql,$myconn);
result_sql($result,$strsql);
$row_y=mysql_fetch_array($result);
//$strsql="select seek_id from $seek_user where userName='$_COOKIE[Seekcokeuser]' and md5(password)='$_COOKIE[Seekcokepass]' limit 0,1";
//$result=mysql_query($strsql,$myconn);
//$num=mysql_num_rows($result);
$num=$_SESSION[Seeksesonseekid];
$Register_date=date("Y-m-d"); if($row_y[zpvip]>=$Register_date or $num){?>
<table width="100%" border=0 cellPadding=3 cellSpacing=3>
<tr>
<td style='padding-left:10px;' colspan='2'>招聘期限： <? echo Change_time($row['Register_date'])?> ~ <? echo $row['EndValid'];?></td>
</tr>
<tr>
<td style='padding-left:10px;' >联 系 人： <? echo $row['ContactPerson'];?><strong><a name="81"></a></strong></td>
<td>工作地区：<? echo $row['JobLocation'];?></td>
</tr>
<tr>
<td colspan="2" style='padding-left:10px;'>联系电话：
<? if($row[TelShowFlag]=='0'){?>
<? echo $row['ContactTel_Z'];?>-<? echo $row['ContactTel'];?>-<? echo $row['ContactTel_E'];?>
<? }else{?>
(合则约见、谢绝来电)
<? }?>
移动电话：<? echo $row['Move_tel']?> </td>
</tr>
<tr>
<td style='padding-left:10px;' colspan='2'>电子邮件：
<? if($row[EmailShowFlag]=='0'){?>
<? $spmail=split('@',$row['Email']);?><a href="public/zpmail.url.php?mail=<? echo $_GET[id]?>@15hr.com.cn&Contactid1=<?php echo $spmail[0];?>&Contactid2=<?php echo $spmail[1];?>" target="_blank"><img src="public/zpmail.gif.php?mail=<? echo $_GET[id]?>@15hr.com.cn&Contactid1=<?php echo $spmail[0];?>&Contactid2=<?php echo $spmail[1];?>" alt="右键显示" border="0"></a>
<? }else{?>
(合则约见、谢绝Email)
<? }?></td>
</tr>
<tr>
<td style='padding-left:10px;' colspan='2'>联系地址： <? echo englishcn($row['Address_P']);?><? echo englishcn($row['Address_C']);?><? echo $row['Address'];?></td>
</tr>
<tr>
<td style='padding-left:10px;' colspan='2'>面试地址： <? echo englishcn($row['ExamAddress_P']);?><? echo englishcn($row['ExamAddress_C']);?><? echo $row['ExamAddress'];?></td>
</tr>
</table>
<br>
<? }else{?>
<table width="100%" height="66" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="66"><div align="center">个人登陆后才能查看联系方式，<a href="Seek_login.php?bankurl=yes&id=<? echo $_GET[id];?>" class="web">点击登陆</a><br>
<br>
如果您还不是会员请按此 <a href="Seek_register.php" class="web">注册成为我们的会员！</a><br>
</div></td>
</tr>
</table>
<? }?></td>
</tr>
<tr>
<td colspan='2' style='padding-left:12px;padding-bottom:20px'>
<table width='416px' cellpadding='3' cellspacing='1' style='border: 1px solid #CCCCCC;'>
<tr>
<td width='32%' bgcolor='#FAFAFA'>学历要求：
<? $ArdegreeId=$row[ReqDegreeID]; if($row[ReqDegreeID]) echo $degreeId[$ArdegreeId].'以上';else echo"不限";?></td>
<td width='68%' bgcolor='#FAFAFA'>工作经验要求：<? if($row[ReqWorkyear]=='-100')echo"不限";elseif($row[ReqWorkyear]=='-1')echo"在读学生";elseif(!$row[ReqWorkyear])echo"毕业生"."以上";else echo $row['ReqWorkyear']."年以上";?></td>
</tr>
<tr>
<td bgcolor='#FAFAFA'>年龄要求：<? if(!$row[ReqAge1] and $row[ReqAge2]==100)echo"不限";else echo $row['ReqAge1'].'-'.$row['ReqAge2'];?></td>
<td bgcolor='#FAFAFA'>性别要求：<? if(!$row[ReqSex])echo"不限";else{ $Arsex=$row[ReqSex]; echo $sex[$Arsex];}?> 现所在地要求：<? if(!$row[ReqLocation] and !$row[otherRequestArea]) echo"不限";else echo $row['ReqLocation'].$row['otherRequestArea'];?></td>
</tr>
</table></td>
</tr>
<tr>
<td height='25' style='padding-left:12px;line-height:20px'><strong>职位描述(Job Descriptions)</strong></td>
</tr>
<tr>
<td height='25' style='padding-left:26px;padding-top:10px;line-height:20px'>招聘人数：<? echo $row['CandidatesNum'];?> 薪资待遇：<? if(!$row[Salary])echo"面议";else echo $row['Salary'];?></td>
</tr>
<tr>
<td height='11' style='padding-left:26px;padding-top:10px;line-height:20px'><? tel_xxx(nl2br($row['PosDescription']));?></td>
</tr><? if($row[ExamNotice]){?>
<tr>
<td height='12' style='padding-left:26px;padding-top:10px;line-height:20px'>面试须知：<? tel_xxx(nl2br($row['ExamNotice']));?></td>
</tr><? }?>
<tr>
<td height='45' align='center' style='padding-left:6px;padding-top:30px;line-height:20px' valign='bottom'><input name="imageField" type="image" src="images/SendIntention_But1.gif" alt="申请该职位" width="115" height="20" border="0">
<a href="Seek_join_db.php?user_id=<? echo $row[zpinfo_id];?>"><img src="images/putfavorite_But.gif" alt="收藏该职位" width="115" height="20" border="0"></a><a onClick="MM_openBrWindow('Seek_join_mail.php?user_id=<? echo $row[zpinfo_id];?>&id=<? echo $Bem_id;?>','','width=500,height=280')"><img src="images/SendFriend_But1.gif" alt="推荐给好友" width="111" height="20"></a></td>
</tr>
<tr>
<td height='30' align='center' style='padding-left:6px;' valign='top'><input type='checkbox' name='show_letter' value='100123'>
<strong>附求职信</strong> <strong><font color='#990000' style='cursor:help;'><a href='help_checkbrowser.php' target='_blank'><u><font color='#990000'>如果点击以上按钮没反应，怎么办？<font></font></font></u></a><? echo"</form>";?></font></strong></td>
</tr>
</table>
<? }?> </td>
<td width="1" bgcolor="#DDDDDA"></td>
</tr>
</table></td>
</tr>
</table>
<div align="center">
<?php include("include/top_2.php"); ?>
</div>
</body>
</html>
欢迎光临 站长论坛 (http://www.tzlink.com/bbs/)
Powered by Discuz! X3.2