include('header.php');
include('left_body.php');
if(isset($_REQUEST['order_by']))
{
$order_by=$_REQUEST['order_by'];
$s=$_REQUEST['s'];
$a=$_REQUEST['a'];
//echo $s.$a;
if($s!="A")
$query_milestones=mysql_query("SElECT * FROM tbl_project WHERE status='$s' AND archieved = '$a' ORDER BY '$order_by' ")or die(mysql_error());
if($s=="A")
$query_milestones=mysql_query("SElECT * FROM tbl_project WHERE archieved = '$a' ORDER BY '$order_by' ")or die(mysql_error());
}
else
{
$s=$_REQUEST['s'];
$a=$_REQUEST['a'];
//echo $s.$a;
if($s!="A")
$query_milestones=mysql_query("SElECT * FROM tbl_project WHERE status='$s' AND archieved = '$a' ")or die(mysql_error());
if($s=="A")
$query_milestones=mysql_query("SElECT * FROM tbl_project WHERE archieved = '$a' ORDER BY 'starting_dt' ")or die(mysql_error());
}
?>
if($s == "P")
{
echo "Proposed";
}
elseif($s == "U")
{
echo "On Going";
}
else
{
echo "Completed";
}
?>
Project Details |
|
|
|
|
include('right_body.php');
include('footer.php');
?>