vacancies_display_latest.php

来自「手机wap源码-PHP-‘Jopshop’」· PHP 代码 · 共 33 行

<? 
session_start();
require_once('../header.php');

if($HTTP_SESSION_VARS['status'] == "logged"){

require_once('../database.php');
	$query = "SELECT title,reference FROM $dbTable_03 where date > date_add(current_date, interval -08 day) ORDER BY date DESC";
	$result = mysql_query($query);
	$db_entryCount = mysql_num_rows($result);
	if($db_entryCount == 0){
print("<card id='direct' title='Sorry' ontimer='vacancies_select.php'>
		<timer value='30'/>
		<p align='center'>
		<img src='../../images/c_head_vacancies.gif' alt='head'/><br/>
		<img src='../../images/c_notice_vacancies_05.gif' alt='Currently is no vacancy available!'/>
		</p>
		</card>
		</wml>");
		exit;
	}

print("<card id='select' title='Latest Vacancies'>
			<p align='center'>
			<a href='vacancies_select.php'><img src='../../images/c_head_vacancies.gif' alt='Vacancies'/><br/><br/></a>
			");

for ($count = 0; $count < $db_entryCount; $count++){
	$thread = mysql_fetch_array($result);
	$db_title = $thread['title'];
	$db_reference = $thread['reference'];
	$v_ref = $count +1;
	print ("<anchor>".$v_ref."