//jobs_list.php
include('../../common/db.php');
include('../../common/conf.php');
include('../../common/constant.php');
include('../../common/functions.php');
$sql = "SELECT project_id, project_name,required_skill, members, work_area, period, upd_date ";
$sql .= "FROM project ";
$sql .= "WHERE active_flag = '1' ";
//$sql .= "WHERE active_flag != '5' OR active_flag IS NULL ";
$sql .= "ORDER BY upd_date DESC ";
$sql .= "LIMIT 0, 1 ";
$rs = mysql_query($sql);
$num_rows = mysql_num_rows($rs);
//echo "sql : $sql
";
$first_project_id = "";
while ($item = mysql_fetch_array($rs)) {
$project_id = $item[0];
$project_name = $item[1];
$required_skill = $item[2];
$members = $item[3];
$work_area = $item[4];
$period = $item[5];
$reg_date = str_replace("-", "-", substr($item[6], 2, 8));
if ($first_project_id == "") {
$first_project_id = $project_id;
}
}
?>
Projects
|
|
FAIL (the browser should render some flash content, not this).
|
|
|
|
|
|
|