session_start();
include "inc/config.inc.php";
include "function/datethai.php";
include "function/function.php";
$title="select * from web_detail where id=1";
$titlere=mysql_query($title) or die("ERROR $title บรททัด4");
$titler=mysql_fetch_row($titlere);
$link="select * from link where id=1";
$linkre=mysql_query($link) or die("ERROR $link บรททัด7");
$linkr=mysql_fetch_row($linkre);
$banner="select * from site_logo where id=1";
$bannerre=mysql_query($banner) or die("ERROR $banner บรททัด10");
$bannerr=mysql_fetch_row($bannerre);
$bg="select * from bg where id=1";
$bgre=mysql_query($bg) or die("ERROR $bg บรททัด13");
$bgr=mysql_fetch_row($bgre);
$footer="select * from footer_logo where id=1";
$refooter=mysql_query($footer) or die("ERROR $footer บรททัด10");
$rfooter=mysql_fetch_row($refooter);
$fb="select * from fanpage where id=1";
$fbre=mysql_query($fb) or die("ERROR $fb บรททัด16");
$fbr=mysql_fetch_row($fbre);
$st="select * from stats where id=1";
$stre=mysql_query($st) or die("ERROR $st บรททัด19");
$str=mysql_fetch_row($stre);
$scn="SELECT * FROM `social_network` WHERE id=1";
$rescn=mysql_query($scn) or die("ERROR $scn");
$rscn=mysql_fetch_row($rescn);
?>
include "header.php"; ?> |
include "box-search.php"; ?> |
include "menu.php"; ?> |
|
หางานได้ทุกที่ทุกเวลา
 |
 |
 |
|
$sjob="SELECT com_job.id, com_job.com_id, com_job.position, com_personal.name, com_job.saraly, ";
$sjob.="com_job.job_date, province.PROVINCE_NAME FROM com_job ";
$sjob.="INNER JOIN com_personal ON com_job.com_id = com_personal.com_id ";
$sjob.="INNER JOIN com_contact ON com_job.com_id = com_contact.com_id ";
$sjob.="INNER JOIN province ON com_contact.province_id = province.PROVINCE_ID ";
$sjob.="ORDER BY com_job.id DESC LIMIT 0,10";
$rejob=mysql_query($sjob) or die("ERROR $sjob");
while($rjob=mysql_fetch_row($rejob)){
$urljob=rewrite($rjob[2]);
$urlcom=rewrite($rjob[3]);
?>
echo mb_substr("$rjob[2]", 0,100,"UTF-8"); ?>...
|
จังหวัด :
|
เงินเดือน :
$s4="select * from salary where id='$rjob[4]'";
$re4=mysql_query($s4) or die("ERROR บรรทัด 141");
$r4=mysql_fetch_row($re4);
echo $r4[1];
?>
|
ประกาศเมื่อ :
$postDate = $rjob[5]; echo DateThai($postDate); ?>
|
|
|
} ?> |
 |
|
|
 |
 |
 |
 |
 |
 |
|
$strSQL="SELECT gov_job.id, gov_job.title, gov_job_contact.logo, gov_job_contact.name, ";
$strSQL.="province.province_name, gov_job.n_position, gov_job.salary, gov_job.post_date ";
$strSQL.="FROM gov_job INNER JOIN gov_job_contact ON gov_job.id = gov_job_contact.gov_id ";
$strSQL.="INNER JOIN province ON gov_job_contact.province_id = province.province_id ";
$strSQL .=" order by gov_job.id DESC LIMIT 0 , 10";
$objQuery=mysql_query($strSQL) or die("ERROR บรรทัด 228");
while($r = mysql_fetch_row($objQuery)){
$urlgov=rewrite($r[1]);
?>
|
|
หน่วยงาน - องค์กร : |
จังหวัด :
|
อัตรา :
|
เงินเดือน :
|
$postDate = $r[7]; echo DateThai($postDate); ?>
|
|
|
|
|
} ?>
|
|
|
 |
 |
 |
|
|
$sads3="SELECT * FROM `ads_a3`";
$reads3=mysql_query($sads3) or die("Error $sads3");
while($rads3=mysql_fetch_row($reads3)){
?>
} ?> |
 |
$strSQL1="SELECT * FROM work_cate ORDER BY CONVERT(cate USING TIS620) ASC ";
$objQuery1 = mysql_query($strSQL1) or die("ERROR $strSQL1");
echo"";
$intRows1= 0;
while($objResult1 = mysql_fetch_row($objQuery1))
{
$urlcate=rewrite2($objResult1[1]);
echo "";
$intRows1++;
?>
echo" | ";
if(($intRows1)%3==0)
{
echo" ";
}
}
echo" ";
?> |
 |
|
|
|
$sads4="SELECT * FROM `ads_a4`";
$reads4=mysql_query($sads4) or die("Error $sads4");
while($rads4=mysql_fetch_row($reads4)){
?>
} ?> |
 |
$strSQL1="SELECT com_benefits.id, com_login.package_id, com_personal.com_id, com_personal.name FROM `com_benefits` ";
$strSQL1.="INNER JOIN com_login ON com_benefits.package_id = com_login.package_id ";
$strSQL1.="INNER JOIN com_personal ON com_login.id = com_personal.com_id ";
$strSQL1.="WHERE com_benefits.com_leading = '1' AND com_login.actived = '1' ORDER BY com_login.id ASC";
$objQuery1 = mysql_query($strSQL1) or die("ERROR บรรทัด 385-388");
echo"";
$intRows1= 0;
while($objResult1 = mysql_fetch_row($objQuery1))
{
$urlcom=rewrite($objResult1[3]);
echo "";
$intRows1++;
?>
|
|
|
$strSQL="SELECT id, position FROM com_job WHERE com_id='$objResult1[2]' ORDER BY RAND() LIMIT 0,4";
$objQuery = mysql_query($strSQL) or die("ERROR $strSQL บรรทัด 428");
echo"";
$intRows= 0;
while($objResult = mysql_fetch_row($objQuery))
{
$urljob=rewrite($objResult[1]);
echo "";
$intRows++;
?>
echo" | ";
if(($intRows)%2==0)
{
echo" ";
}
}
echo" ";
?> |
|
echo" | ";
if(($intRows1)%2==0)
{
echo" ";
}
}
echo" ";
?> |
 |
 |
$sads1="SELECT * FROM `ads_a5`";
$reads1=mysql_query($sads1) or die("Error $sads1");
echo"";
$intRows= 0;
while($rads1=mysql_fetch_row($reads1))
{
echo "";
$intRows++;
?>
echo" | ";
if(($intRows)%3==0)
{
echo" ";
}
}
echo" ";
?> |
 |
 |
$strSQL1="SELECT emp_personal.emp_id, emp_work.position1, emp_personal.sex, ";
$strSQL1.="emp_personal.age, emp_personal.name, emp_edu.max_edu, emp_edu.max_major, ";
$strSQL1.="emp_contact.province_id, province.province_name, emp_work.salary1 ";
$strSQL1.="FROM emp_personal ";
$strSQL1.="INNER JOIN emp_work ON emp_personal.emp_id = emp_work.emp_id ";
$strSQL1.="INNER JOIN emp_edu ON emp_personal.emp_id = emp_edu.emp_id ";
$strSQL1.="INNER JOIN emp_contact ON emp_personal.emp_id = emp_contact.emp_id ";
$strSQL1.="INNER JOIN province ON emp_contact.province_id = province.province_id ";
$strSQL1.="ORDER BY emp_personal.emp_id DESC LIMIT 0,12";
$objQuery1 = mysql_query($strSQL1) or die("ERROR บรรทัด 226-234");
echo"";
$intRows1= 0;
while($objResult1 = mysql_fetch_row($objQuery1))
{
echo "";
$intRows1++;
?>
echo" | ";
if(($intRows1)%4==0)
{
echo" ";
}
}
echo" ";
?> |
 |
|
|
$spro="SELECT * FROM province ORDER BY province_id ASC";
$repro = mysql_query($spro) or die("ERROR $spro");
echo"";
$intRpro= 0;
while($rpro = mysql_fetch_row($repro))
{
$urlprov=rewrite($rpro[1]);
echo "";
$intRpro++;
?>
echo" | ";
if(($intRpro)%5==0)
{
echo" ";
}
}
echo" ";
?> |
|
|
include "footer.php"; ?> |