//jobs_inner_list.php
include('../../common/db.php');
include('../../common/conf.php');
include('../../common/constant.php');
include('../../common/functions.php');
//echo "sql : $sql
";
?>
$sql = "SELECT project_id, project_name,required_skill, members, work_area, period, reg_date ";
$sql .= "FROM project ";
$sql .= "WHERE active_flag = '1' ";
//$sql .= "WHERE active_flag = '' OR active_flag IS NULL ";
$sql .= "ORDER BY reg_date DESC, upd_date DESC ";
$sql .= "LIMIT 0, 30 ";
$rs = mysql_query($sql);
$num_rows = mysql_num_rows($rs);
$first_project_id = "";
if($num_rows == 0 or $num_rows ==""){
$reg_date = "No news Arrived";
$project_name = "We are waiting your ideas!";
$project_id = "";
?>
|