|
Sample Code:
<![CDATA[
<?php
if (isset($_POST['selemployee']))
{
$selemployee=$_POST['selemployee'];
}
else
{
$selemployee="";
}
?>
Employee Name:
<select id="selemployee" name="selemployee" >
<option <?php if ($selemployee=="") {echo "Selected ";}?> VALUE="">All</option>
<?php
$query="select distinct e.employee_id, employee_name from employee_details e,
employee_involved_project ep where e.employee_id=ep.employee_id
order by e.employee_name";
$result=mysql_query($query,$Link);
while($row=mysql_fetch_array($result, MYSQL_ASSOC))
{
?>
<option <?php if ($selemployee==$row['employee_id']) {echo "Selected ";}?>
value="<?php echo $row['employee_id']; ?>"><?php echo $row['employee_name']; ?>
</option>
<?php
}
?>
</select>
<?php
$reportquery="select * from project_details p, employee_details e, timesheet_status t
where p.projectid=t.project_id and e.employee_id=t.employee_id and time_spent! =0";
$result=mysql_query ($reportquery, $Link);
//Employee filter
if ($selemployee!="")
{
$reportquery.=" and e.employee_id='$selemployee' ";
}
$result=mysql_query($reportquery,$Link);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo $employee_name=$row['employee_name']."<br>";
echo $project_name=$row['projectname'];
}
?>
]]>
|