vacancies_display_sorted.php

手机wap源码-PHP-‘Jopshop’

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

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

require_once('../database.php');
	$query = "SELECT category FROM $dbTable_03 ORDER BY category ASC";
	$result = mysql_query($query);
	$db_entryCount = mysql_num_rows($result);

	$display_category = array();

print("<card id='select' title='Sorted Vacancies'>
			<p align='center'>
			<br/><select name='selected_category' title='Please Select!'>");

for ($count = 0; $count < $db_entryCount; $count++){
	$thread = mysql_fetch_array($result);
	$db_category  = $thread['category'];
	if(!in_array($db_category,$display_category))
	{
		$display_category[]=$db_category;
	}
	}
	foreach($display_category as $value){
	print  "<option value=\"".htmlspecialchars($value)."\">".htmlspecialchars($value)."</option>";
	
}
	
	print ("</select>
			<anchor>
			<br/>